Martijn van Oosterhout <> writes:
> In the CVS version there is a table with this information:

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.

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.

                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Reply via email to