Re: Timezone List

On Thu, Sep 07, 2006 at 04:07:58AM +1000, Naz Gassiep wrote:
> Any chance for a DB Client accessible list of allowable time zones? I've
> been told that the only way to get at this list is by looking through
> the source and lifting the list from zone.tab.

In the CVS version there is a table with this information:

http://developer.postgresql.org/pgdocs/postgres/view-pg-timezonenames.html

> While I'm at it, how about an accessible list of country codes? I know
> that it's not core db functionality, but these lists are so universally
> useful that making users parse the files and store them in tables seems
> silly.

Err, where does postgres use this information? I beleive there is a
project on pgfoundary that has some standard datasets.

Hope this helps,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.