[postgis-users] Merge all polygons from a dataset

[Randall, Eric]

As others have mentioned somewhere, you could also use:
 
select st_buffer(st_collect(the_geom),0) from yourpolytable
 
Eric
 

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net [mailto:postgis-users-bounces at postgis.refractions.net]On Behalf Of danny
Sent: Friday, August 01, 2008 6:12 AM
To: postgis-users at postgis.refractions.net
Subject: [postgis-users] Merge all polygons from a dataset


Hello everybody,

I've converted a shapefile of Europe to PostGIS. I would like to merge all the countries together so that I only have one polygon left, the whole contour of Europe. I have tried ST_Union that gives me no result. I've tried several other functions to no avail. Does anybody know how I should proceed?

Many thanks,

Erik


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20080801/6d8421b7/attachment.html>