<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.6000.16681" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=809422312-01082008>As
others have mentioned somewhere, you could also use:</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=809422312-01082008></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=809422312-01082008>select
st_buffer(st_collect(the_geom),0) from yourpolytable</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=809422312-01082008></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=809422312-01082008>Eric</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B>
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net]<B>On Behalf Of
</B>danny<BR><B>Sent:</B> Friday, August 01, 2008 6:12 AM<BR><B>To:</B>
postgis-users@postgis.refractions.net<BR><B>Subject:</B> [postgis-users] Merge
all polygons from a dataset<BR><BR></FONT></DIV>
<DIV dir=ltr>Hello everybody,<BR><BR>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?<BR><BR>Many
thanks,<BR><BR>Erik<BR></DIV></BLOCKQUOTE></BODY></HTML>