Re: Download States and Capitals Database

On 28/09/11 13:43, Johan De Meersman wrote:
>
> ----- Original Message -----
>> From: "Adarsh Sharma" <adarsh(dot)sharma(at)orkash(dot)com>
>>
>> This Link gives the capitals of all countries but I need the states
>> and their capitals in all these countries too..
>> But I think this is not possible because very few countries are
>> divided into states and some into cantons, county etc.
>
> Yep. The only one I can think of off the top of my head is the USA, although I can't exactly claim accurate geopolitical knowledge about the whole world :)

Australia has states, as does India.

I won't be shocked to hear that there's somewhere with more than two
levels, eg country->state->province->provincial capital .

BTW, Adarsh, you seem to have cross-posted to the MySQL mailing list.
Cross posting is rude enough when you're cross-posting to several Pg
lists, but intermingling mysql and Pg mailing list replies is just going
to get messy. PLEASE DO NOT POST MESSAGES TO MORE THAN ONE MAILING LIST
IN THE SAME MESSAGE.

--
Craig Ringer