[postgis-users] Interior rings

[paul.malm at lfv.se]

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.
/Paul
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20190813/885ae00b/attachment.html>