Documentation → PostgreSQL 9.2

Supported Versions: Current (17) / 16 / 15 / 14 / 13

Development Versions: devel

Unsupported versions: 12 / 11 / 10 / 9.6 / 9.5 / 9.4 / 9.3 / 9.2 / 9.1 / 9.0 / 8.4 / 8.3 / 8.2

This documentation is for an unsupported version of PostgreSQL.
You may want to view the same page for the current version, or one of the other supported versions listed above instead.

PostgreSQL 9.2.24 Documentation
Prev	Up	Chapter 45. System Catalogs	Next

45.69. `pg_timezone_names`

The view pg_timezone_names provides a list of time zone names that are recognized by SET TIMEZONE, along with their associated abbreviations, UTC offsets, and daylight-savings status. (Technically, PostgreSQL uses UT1 rather than UTC because leap seconds are not handled.) Unlike the abbreviations shown in pg_timezone_abbrevs, many of these names imply a set of daylight-savings transition date rules. Therefore, the associated information changes across local DST boundaries. The displayed information is computed based on the current value of CURRENT_TIMESTAMP.

Table 45-70. pg_timezone_names Columns

Name	Type	Description
`name`	`text`	Time zone name
`abbrev`	`text`	Time zone abbreviation
`utc_offset`	`interval`	Offset from UTC (positive means east of Greenwich)
`is_dst`	`boolean`	True if currently observing daylight savings

Prev	Home	Next
`pg_timezone_abbrevs`	Up	`pg_user`

45.69. pg_timezone_names

45.69. `pg_timezone_names`