[postgis-users] Linestrings and MultiLiestrings to Linestrings

paul.malm at lfv.se paul.malm at lfv.se
Tue Sep 3 09:29:31 PDT 2019


Yes, thanks!

3 sep. 2019 kl. 05:36 skrev Bo Victor Thomsen <bo.victor.thomsen at gmail.com<mailto:bo.victor.thomsen at gmail.com>>:


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 paul.malm at lfv.se<mailto:paul.malm at lfv.se>:
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
postgis-users at lists.osgeo.org<mailto:postgis-users at lists.osgeo.org>
https://lists.osgeo.org/mailman/listinfo/postgis-users

_______________________________________________
postgis-users mailing list
postgis-users at lists.osgeo.org<mailto:postgis-users at lists.osgeo.org>
https://lists.osgeo.org/mailman/listinfo/postgis-users


More information about the postgis-users mailing list