<html><body><div style="color:#000; background-color:#fff; font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:16px"><div class="" style="">SELECT id, name, st_dump(st_boundary(the_geom))</div><div></div><div class="" style=""> FROM poly_and_multipoly;</div><div dir="ltr" class="" style=""><br class="" style=""></div><div dir="ltr" class="" style="">Yes, with st_dump...that seems to be the right result. Thanks!</div> <div class="" style="" id="yui_3_16_0_1_1434312083387_2780"><span class="" style=""><br class="" style=""></span></div><br><div class="qtdSeparateBR"><br><br></div><div class="yahoo_quoted" style="display: block;"> <div style="font-family: HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif; font-size: 16px;"> <div style="font-family: HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif; font-size: 16px;"> <div dir="ltr"> <font size="2" face="Arial"> On Saturday, June 13, 2015 1:04 AM, Sandro Santilli <strk@keybit.net> wrote:<br> </font> </div> <br><br> <div class="y_msg_container">On Fri, Jun 12, 2015 at 11:51:35PM +0000, Ruth Simm wrote:<div class="yqt6009590140" id="yqtfd66352"><br clear="none"><br clear="none">> There seems to be a host of options for going from LineString to Polygon<br clear="none">> (ST_MakePolygon) - but not much for going the other way.</div><br clear="none"><br clear="none">See ST_Boundary - <a shape="rect" href="http://postgis.net/docs/ST_Boundary.html" target="_blank">http://postgis.net/docs/ST_Boundary.html</a><br clear="none"><br clear="none">--strk;<div class="yqt6009590140" id="yqtfd75009"><br clear="none"></div><br><br></div> </div> </div> </div></div></body></html>