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.