Re: Download States and Capitals Database

Craig Ringer wrote:
> 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.
>

Really Apologies my mistake and fell sorry for that.
I will take care about this in future.

Thanks
>