Documentation → PostgreSQL 8.4

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 8.4.22 Documentation
Prev	Fast Backward	Chapter 44. System Catalogs	Fast Forward	Next

44.57. `pg_timezone_abbrevs`

The view pg_timezone_abbrevs provides a list of time zone abbreviations that are currently recognized by the datetime input routines. The contents of this view change when the timezone_abbreviations run-time parameter is modified.

Table 44-58. pg_timezone_abbrevs Columns

Name	Type	Description
`abbrev`	`text`	Time zone abbreviation
`utc_offset`	`interval`	Offset from UTC (positive means east of Greenwich)
`is_dst`	`boolean`	True if this is a daylight-savings abbreviation

Prev	Home	Next
`pg_tables`	Up	`pg_timezone_names`

44.57. pg_timezone_abbrevs

44.57. `pg_timezone_abbrevs`