https://gis.stackexchange.com/questions/49950/converting-mulitlinestring-to-linestring-in-postgresql-with-postgis/49994

If you simply want to have a single type in your table it's much easier to convert the linestrings to mutilinestrings using this command like this

|ALTERTABLEmy_table ALTERCOLUMNgeom TYPE geometry(MultiLineString,4326)USINGST_Multi(geom);|

(You'll have change the above command regarding table- and column names  and crs id)

--
Med venlig hilsen / Kind regards

Bo Victor Thomsen

Den 02-09-2019 kl. 09:23 skrev [email protected]:

Hi,

I have a table (bufferedlines) with a geometry column (the_geom)  including both Linestrings and MultiLinestrings, what is the easiest way to change the_geom to a Linestring column?

Kind regards,

Paul


_______________________________________________
postgis-users mailing list
[email protected]
https://lists.osgeo.org/mailman/listinfo/postgis-users

_______________________________________________
postgis-users mailing list
[email protected]
https://lists.osgeo.org/mailman/listinfo/postgis-users

Reply via email to