[postgis-users] Multipolygon

[Maxime van Noppen]

On 09/21/09 18:50, eehab hamzeh wrote:
> Hello
> 
> Is there are any command work like st_makeline to create a multipolygon.
> I have a table with a different record of polygon. I need to create
> multipolygon from them
> 
> Any hint or directions

SELECT ST_Union(geom) FROM table;

This will perform the union of all the geometries in the geom column of
table. If you want to force the output type to Multipolygon :

SELECT ST_Multi(ST_Union(geom)) FROM table;


-- 
Maxime