[postgis-users] Learn how to create LineStrings from Polygons and Multipolygons

[Ruth Simm]

SELECT id, name, st_dump(st_boundary(the_geom))  FROM poly_and_multipoly;
Yes, with st_dump...that seems to be the right result. Thanks! 



     On Saturday, June 13, 2015 1:04 AM, Sandro Santilli <strk at keybit.net> wrote:
   

 On Fri, Jun 12, 2015 at 11:51:35PM +0000, Ruth Simm wrote:

> There seems to be a host of options for going from LineString to Polygon
> (ST_MakePolygon) - but not much for going the other way.

See ST_Boundary - http://postgis.net/docs/ST_Boundary.html

--strk;


  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20150614/38ab643c/attachment.html>