[postgis-users] Linestrings and MultiLiestrings to Linestrings

[Bo Victor Thomsen]

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 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
> https://lists.osgeo.org/mailman/listinfo/postgis-users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20190903/69ee3117/attachment.html>