[postgis-users] Removing holes from polygons

[Akhil Jaggarwal]

Hi,

I've a table T1 containing geometry of Regions (Arctic, Atlantic
Ocean) exploded from mulipolygons into polygons which have holes in it
(islands).

My another table T1_subset consists of a geometry dataset which is
actually a subset of the the regions found in Table T1. Turns out that
the subset query to find out regions in Table T2 contained the Region
Polygons takes a lot of time because of the holes contained in the
polygons in T1.

Any tips or hints on a query which removes all the inner holes from a
polygon and returns and keeps the geometry of the largest one intact?

-Akhil