pg_timezone_abbrevs
A system view providing a list of time zone abbreviations
pg_timezone_abbrevs is a system catalogue view providing a list of time zone abbreviations that are currently recognized by the datetime input routines.
pg_timezone_abbrevs was added in PostgreSQL 8.2.
Definition by PostgreSQL version
pg_timezone_abbrevs (PostgreSQL 16)
View "pg_catalog.pg_timezone_abbrevs"
Column | Type | Collation | Nullable | Default
------------+----------+-----------+----------+---------
abbrev | text | | |
utc_offset | interval | | |
is_dst | boolean | | |
Documentation: pg_timezone_abbrevs
pg_timezone_abbrevs (PostgreSQL 15)
View "pg_catalog.pg_timezone_abbrevs"
Column | Type | Collation | Nullable | Default
------------+----------+-----------+----------+---------
abbrev | text | | |
utc_offset | interval | | |
is_dst | boolean | | |
Documentation: pg_timezone_abbrevs
pg_timezone_abbrevs (PostgreSQL 14)
View "pg_catalog.pg_timezone_abbrevs"
Column | Type | Collation | Nullable | Default
------------+----------+-----------+----------+---------
abbrev | text | | |
utc_offset | interval | | |
is_dst | boolean | | |
Documentation: pg_timezone_abbrevs
pg_timezone_abbrevs (PostgreSQL 13)
View "pg_catalog.pg_timezone_abbrevs"
Column | Type | Collation | Nullable | Default
------------+----------+-----------+----------+---------
abbrev | text | | |
utc_offset | interval | | |
is_dst | boolean | | |
Documentation: pg_timezone_abbrevs
pg_timezone_abbrevs (PostgreSQL 12)
View "pg_catalog.pg_timezone_abbrevs"
Column | Type | Collation | Nullable | Default
------------+----------+-----------+----------+---------
abbrev | text | | |
utc_offset | interval | | |
is_dst | boolean | | |
Documentation: pg_timezone_abbrevs
pg_timezone_abbrevs (PostgreSQL 11)
View "pg_catalog.pg_timezone_abbrevs"
Column | Type | Collation | Nullable | Default
------------+----------+-----------+----------+---------
abbrev | text | | |
utc_offset | interval | | |
is_dst | boolean | | |
Documentation: pg_timezone_abbrevs
pg_timezone_abbrevs (PostgreSQL 10)
View "pg_catalog.pg_timezone_abbrevs"
Column | Type | Collation | Nullable | Default
------------+----------+-----------+----------+---------
abbrev | text | | |
utc_offset | interval | | |
is_dst | boolean | | |
Documentation: pg_timezone_abbrevs
pg_timezone_abbrevs (PostgreSQL 9.6)
View "pg_catalog.pg_timezone_abbrevs"
Column | Type | Modifiers
------------+----------+-----------
abbrev | text |
utc_offset | interval |
is_dst | boolean |
Documentation: pg_timezone_abbrevs
pg_timezone_abbrevs (PostgreSQL 9.5)
View "pg_catalog.pg_timezone_abbrevs"
Column | Type | Modifiers
------------+----------+-----------
abbrev | text |
utc_offset | interval |
is_dst | boolean |
Documentation: pg_timezone_abbrevs
pg_timezone_abbrevs (PostgreSQL 9.4)
View "pg_catalog.pg_timezone_abbrevs"
Column | Type | Modifiers
------------+----------+-----------
abbrev | text |
utc_offset | interval |
is_dst | boolean |
Documentation: pg_timezone_abbrevs
pg_timezone_abbrevs (PostgreSQL 9.3)
View "pg_catalog.pg_timezone_abbrevs"
Column | Type | Modifiers
------------+----------+-----------
abbrev | text |
utc_offset | interval |
is_dst | boolean |
Documentation: pg_timezone_abbrevs
pg_timezone_abbrevs (PostgreSQL 9.2)
View "pg_catalog.pg_timezone_abbrevs"
Column | Type | Modifiers
------------+----------+-----------
abbrev | text |
utc_offset | interval |
is_dst | boolean |
Documentation: pg_timezone_abbrevs
pg_timezone_abbrevs (PostgreSQL 9.1)
View "pg_catalog.pg_timezone_abbrevs"
Column | Type | Modifiers
------------+----------+-----------
abbrev | text |
utc_offset | interval |
is_dst | boolean |
Documentation: pg_timezone_abbrevs
pg_timezone_abbrevs (PostgreSQL 9.0)
View "pg_catalog.pg_timezone_abbrevs"
Column | Type | Modifiers
------------+----------+-----------
abbrev | text |
utc_offset | interval |
is_dst | boolean |
Documentation: pg_timezone_abbrevs
pg_timezone_abbrevs (PostgreSQL 8.4)
View "pg_catalog.pg_timezone_abbrevs"
Column | Type | Modifiers
------------+----------+-----------
abbrev | text |
utc_offset | interval |
is_dst | boolean |
View definition:
SELECT pg_timezone_abbrevs.abbrev, pg_timezone_abbrevs.utc_offset, pg_timezone_abbrevs.is_dst
FROM pg_timezone_abbrevs() pg_timezone_abbrevs(abbrev, utc_offset, is_dst);
Documentation: pg_timezone_abbrevs
pg_timezone_abbrevs (PostgreSQL 8.3)
View "pg_catalog.pg_timezone_abbrevs"
Column | Type | Modifiers
------------+----------+-----------
abbrev | text |
utc_offset | interval |
is_dst | boolean |
View definition:
SELECT pg_timezone_abbrevs.abbrev, pg_timezone_abbrevs.utc_offset, pg_timezone_abbrevs.is_dst
FROM pg_timezone_abbrevs() pg_timezone_abbrevs(abbrev, utc_offset, is_dst);
Documentation: pg_timezone_abbrevs
pg_timezone_abbrevs (PostgreSQL 8.2)
View "pg_catalog.pg_timezone_abbrevs"
Column | Type | Modifiers
------------+----------+-----------
abbrev | text |
utc_offset | interval |
is_dst | boolean |
View definition:
SELECT pg_timezone_abbrevs.abbrev, pg_timezone_abbrevs.utc_offset, pg_timezone_abbrevs.is_dst
FROM pg_timezone_abbrevs() pg_timezone_abbrevs(abbrev, utc_offset, is_dst);
Documentation: pg_timezone_abbrevs
Change history
pg_timezone_abbrevs has not been modified since it was added in PostgreSQL 8.2.
- PostgreSQL 8.2
- added (commit d8b5c95c)
Examples
postgres=# SELECT * FROM pg_timezone_abbrevs WHERE abbrev LIKE 'C%'; abbrev | utc_offset | is_dst --------+------------+-------- CADT | 10:30:00 | t CAST | 09:30:00 | f CCT | 08:00:00 | f CDT | -05:00:00 | t CEST | 02:00:00 | t CET | 01:00:00 | f CETDST | 02:00:00 | t CHADT | 13:45:00 | t CHAST | 12:45:00 | f CHUT | 10:00:00 | f CKT | -10:00:00 | f CLST | -03:00:00 | t CLT | -04:00:00 | f COT | -05:00:00 | f CST | -06:00:00 | f CXT | 07:00:00 | f (16 rows)
References
- PostgreSQL documentation: pg_timezone_abbrevs