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