Re: Timezone List - Mailing list pgsql-hackers

From Martijn van Oosterhout
Subject Re: Timezone List
Date
Msg-id 20060906182016.GC28348@svana.org
Whole thread Raw
In response to Timezone List  (Naz Gassiep <naz@mira.net>)
Responses Re: Timezone List  (Naz Gassiep <naz@mira.net>)
Re: Timezone List  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
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@svana.org>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

pgsql-hackers by date:

Previous
From: Naz Gassiep
Date:
Subject: Timezone List
Next
From: Naz Gassiep
Date:
Subject: Re: Timezone List