How to get Place Names from Lat Lon - Mailing list pgsql-general

From Adarsh Sharma
Subject How to get Place Names from Lat Lon
Date
Msg-id 4ED7692B.3000808@orkash.com
Whole thread Raw
Responses Re: How to get Place Names from Lat Lon  (Josh Kupershmidt <schmiddy@gmail.com>)
List pgsql-general
Dear all,

I have a position table that contains the lat lon of an entity from time
to time.
Now I want to get the place names from the respective lat lon.

In the past , I  am able to get the country names in which the lat lon
falls because I have a table that contains the geom of all countries.
But now, I want to know the city name too fore.g Delhi , Bangalore ,
canada, netherland etc.

Is it possible, pls let me know.


Thanks

pgsql-general by date:

Previous
From: "Albe Laurenz"
Date:
Subject: Re: Strange problem with turning WAL archiving on
Next
From: Gracjan Polak
Date:
Subject: Problem with binary data transfer format of TEXT in 8.4