[postgis-users] Interior rings

paul.malm at lfv.se paul.malm at lfv.se
Tue Aug 13 07:39:16 PDT 2019

Hi, I would like to create a table with all the interior rings (islands) from a table with multipolygons lakes.
I've only come this far:
CREATE TABLE "islands" AS SELECT  (ST_InteriorRingn(the_geom, 2)).geometry AS the_geom FROM public."lakes";
But this is only collecting the first island in each lake.
Thankful for any suggestions.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20190813/885ae00b/attachment.html>

More information about the postgis-users mailing list