[postgis-users] Union a very big Multipolygon table with self intersections

[Javier de la Torre]

Hi all,

I have a table with a MULTIPOLYGON field with around 100k records. Some of these records, 2K have self intersections and other problems that make ST_IsValid return false. The polygons overlap a lot and I wanted to generate another table that will be the union of all polygons.

The table looks like 
id, the_geom

What would be the best way to union all of the geometries into a new table where there is only POLYGONS that do not overlap?

Thanks in advance.

Javier.