On Wed, 6 Sep 2006, Tom Lane wrote: > Martijn van Oosterhout <kleptog@svana.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. > > 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.
I think 'abbrev' is a like unintuitive. How about 'short_names'? Gavin ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
