Re: Timezone List

On 2006-09-06, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Martijn van Oosterhout <kleptog(at)svana(dot)org> writes:
>> In the CVS version there is a table with this information:
>> http://developer.postgresql.org/pgdocs/postgres/view-pg-timezonenames.html
>
> Actually, what that view gives you is timezone offset abbreviations, not
> the full zone names that you could use with SET TIME ZONE. It strikes
> me that we should have a view for that as well. We could use code
> similar to scan_available_timezones() to generate the view output.

Any view over the full timezone names should also include the corresponding
data from zone.tab in the timezone library source.

> It's somewhat urgent to address this now, because pg_timezonenames is
> sitting on the obvious name for such a view, and once we release 8.2
> we won't be able to change it. On reflection I think the existing view
> is wrongly named --- perhaps it should be pg_timezoneabbrevs? Or
> more readably, perhaps pg_timezone_abbrevs, with pg_timezone_names for
> the other view.

Yes, the abbreviations table is definitely misnamed.

--
Andrew, Supernews
http://www.supernews.com - individual and corporate NNTP services