pgrouting

SELECT seq, id1 AS node, id2 AS edge, cost,geom into dijkstra_result FROM pgr_dijkstra('

SELECT gid AS id,                    

source::integer,                       

target::integer,                      

length::double precision AS cost

FROM nyc_streets',

1, 2, false, false) as di

join nyc_streets pt

on di.id2 = pt.gid;