> which is actually a continuous line. The only reason this got in as a > Multilinestring is because the the original shapefile provided to > shp2pgsql was having Multilinestrings as the default data type. > then you should reload your shapefile, using the -S switch to force creation of simple objects. Or else try using st_line_merge(). Nicolas