[postgis-users] searching a valid query to return the borders of a country

[Torsten Mohr]

Hello,

i'm searching for an SQL query that returns the borders of a country or 
better, _all_ countries.

For testing i tried queries like:

select name, way from planet_osm_polygon where admin_level <> '' and 
name='Ireland';

This returns one Polygon that, when drawn, looks like Ireland.

Doing the same for "Deutschland" returns six polygons, of which none looks 
like "Deutschland", more like some of the islands around it.

What is the best way to get the borders of a country?


Best regards,
Torsten.