[postgis-users] SQL Query to get the polygons that make up a country?

[Torsten Mohr]

Hi,

i just re-installed PostGIS and imported an OSM planet file.

I'd like to formulate a query that gives me the borders of a country in 
latitute / longitude.

I already got a query (with help from this list) to get all capitols:

select st_X(wayLL), st_Y(wayLL), name from (select 
ST_AsText(ST_Transform(way,4326)) as wayLL, name from planet_osm_point where 
capital='yes') as foo limit 5;

This query works quite fine.


Can anybody give me a hint what would be a valid query to get one (or more !) 
polygons that make up a country (if that country covers two or more areas or 
has holes in it)?


Thanks for any hints,
Torsten.