I would like to calculate the shortest path with dijkstra algorithm.
SELECT seq, id1 AS node, id2 AS edge, cost FROM pgr_dijkstra('
SELECT gid AS id,
length::double precision AS cost
30, 60, false, false);
I imported an osm map, it has proper network. The name of the table is
at_2po_4pgr, colums are
id, osm_id, osm_name, osm_meta, osm_source_id, osm_target_id, clazz, flags, source, target, km, kmh, cost, reverse_cost, x1, y1, x2, y2, geom_way.
in result I would like to see the shortest path and streets name in a row where route was planning.