On 2 August 2017 at 23:03, <j...@sanchezsabe.com> wrote: > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/9.6/static/view-pg-timezone-names.html > Description: > > With regard to documentation page: > > https://www.postgresql.org/docs/current/static/view-pg-timezone-names.html > > Testing: > > SELECT name, abbrev, utc_offset, is_dst FROM pg_catalog.pg_timezone_abbrevs > ;
The documentation page you've referred to is for pg_timezone_names, not pg_timezone_abbrevs. The page for pg_timezone_abbrevs doesn't mention a "name" column: https://www.postgresql.org/docs/current/static/view-pg-timezone-abbrevs.html > > ... produces the error > > ERROR: column "name" does not exist > LINE 1: SELECT name, abbrev, utc_offset, is_dst FROM pg_timezone_abb... > > Apparently, the column "name" isn't there any more. > > SELECT * FROM pg_catalog.pg_timezone_abbrevs LIMIT 1; > > produces > > abbrev | utc_offset | is_dst > :----- | :--------- | :----- > ACDT | 10:30:00 | t > > Either the table (or view) is lacking a column, or the documentation is > wrong. > > Tested on PostgreSQL 9.6.2 at > http://dbfiddle.uk/?rdbms=postgres_9.6&fiddle=9f367fa77616ddf9af721091366bd792 Thom -- Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs
