Yes, thanks!

3 sep. 2019 kl. 05:36 skrev Bo Victor Thomsen 
<[email protected]<mailto:[email protected]>>:


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

ALTER TABLE my_table
    ALTER COLUMN geom TYPE geometry(MultiLineString,4326) USING ST_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]<mailto:[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]<mailto:[email protected]>
https://lists.osgeo.org/mailman/listinfo/postgis-users

_______________________________________________
postgis-users mailing list
[email protected]<mailto:[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