Postgres-XC 1.2.1 Documentation
PrevFast BackwardChapter 47. System CatalogsFast ForwardNext

47.73. pg_timezone_abbrevs

Note: The following description applies both to Postgres-XC and PostgreSQL if not described explicitly. You can read PostgreSQL as Postgres-XC except for version number, which is specific to each product.

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 47-74. pg_timezone_abbrevs Columns

NameTypeDescription
abbrevtextTime zone abbreviation
utc_offsetintervalOffset from UTC (positive means east of Greenwich)
is_dstbooleanTrue if this is a daylight-savings abbreviation
PrevHomeNext
pg_tablesUppg_timezone_names