Hi all,
I am creating a database-backed website using Postgres and will have a dropdown where the user will select his/her state of residence. What I want is for this dropdown to be populated by a table containing rows for all 50 states. My question: Is there a premade table I can obtain somewhere and import into my database so I don't have to key in all this data manually? I also conceivably see my website going global, so I'd also like information on a premade table containing rows for the 150+ nations currently recognised. Any help is greatly appreciated.

Google is your friend
http://www.google.com/search?hl=en&s...of+state+codes