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 <firstname.lastname@example.org> http://svana.org/kleptog/ > From each according to his ability. To each according to his ability to > litigate.
Description: Digital signature