Openstreetmap how to get a list of countries, regions, localities?

Question

PostgreSQL

There is a database in postgresql, which is formed using osm2pgsql. It is necessary to get a list of countries, a list of regions of a particular country, and a list of settlements in this region. How can this be done with SQL queries?

Answer 1

https://postgis.net/docs/ST_Within.html