[postgis-users] Merge all polygons from a dataset

Randall, Eric ERandall at eriecountygov.org
Fri Aug 1 05:27:11 PDT 2008

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

-----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,


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

More information about the postgis-users mailing list