pg_timezone_names

A system catalogue view providing a list of time zone names that are recognized by SET TIMEZONE

pg_timezone_names is a system catalogue view providing a list of time zone names that are recognized by SET TIMEZONE.

pg_timezone_names was added in PostgreSQL 8.2 (commit d8b5c95c).

Definition by PostgreSQL version

pg_timezone_names (PostgreSQL 13)

          View "pg_catalog.pg_timezone_names"
   Column   |   Type   | Collation | Nullable | Default
------------+----------+-----------+----------+---------
 name       | text     |           |          |
 abbrev     | text     |           |          |
 utc_offset | interval |           |          |
 is_dst     | boolean  |           |          |
    

Documentation: pg_timezone_names

pg_timezone_names (PostgreSQL 12)

          View "pg_catalog.pg_timezone_names"
   Column   |   Type   | Collation | Nullable | Default
------------+----------+-----------+----------+---------
 name       | text     |           |          |
 abbrev     | text     |           |          |
 utc_offset | interval |           |          |
 is_dst     | boolean  |           |          |
    

Documentation: pg_timezone_names

pg_timezone_names (PostgreSQL 11)

          View "pg_catalog.pg_timezone_names"
   Column   |   Type   | Collation | Nullable | Default
------------+----------+-----------+----------+---------
 name       | text     |           |          |
 abbrev     | text     |           |          |
 utc_offset | interval |           |          |
 is_dst     | boolean  |           |          |
    

Documentation: pg_timezone_names

pg_timezone_names (PostgreSQL 10)

          View "pg_catalog.pg_timezone_names"
   Column   |   Type   | Collation | Nullable | Default
------------+----------+-----------+----------+---------
 name       | text     |           |          |
 abbrev     | text     |           |          |
 utc_offset | interval |           |          |
 is_dst     | boolean  |           |          |
    

Documentation: pg_timezone_names

pg_timezone_names (PostgreSQL 9.6)

View "pg_catalog.pg_timezone_names"
   Column   |   Type   | Modifiers
------------+----------+-----------
 name       | text     |
 abbrev     | text     |
 utc_offset | interval |
 is_dst     | boolean  |
    

Documentation: pg_timezone_names

pg_timezone_names (PostgreSQL 9.5)

View "pg_catalog.pg_timezone_names"
   Column   |   Type   | Modifiers
------------+----------+-----------
 name       | text     |
 abbrev     | text     |
 utc_offset | interval |
 is_dst     | boolean  |
    

Documentation: pg_timezone_names

pg_timezone_names (PostgreSQL 9.4)

View "pg_catalog.pg_timezone_names"
   Column   |   Type   | Modifiers
------------+----------+-----------
 name       | text     |
 abbrev     | text     |
 utc_offset | interval |
 is_dst     | boolean  |
    

Documentation: pg_timezone_names

pg_timezone_names (PostgreSQL 9.3)

View "pg_catalog.pg_timezone_names"
   Column   |   Type   | Modifiers
------------+----------+-----------
 name       | text     |
 abbrev     | text     |
 utc_offset | interval |
 is_dst     | boolean  |
    

Documentation: pg_timezone_names

pg_timezone_names (PostgreSQL 9.2)

View "pg_catalog.pg_timezone_names"
   Column   |   Type   | Modifiers
------------+----------+-----------
 name       | text     |
 abbrev     | text     |
 utc_offset | interval |
 is_dst     | boolean  |
    

Documentation: pg_timezone_names

pg_timezone_names (PostgreSQL 9.1)

View "pg_catalog.pg_timezone_names"
   Column   |   Type   | Modifiers
------------+----------+-----------
 name       | text     |
 abbrev     | text     |
 utc_offset | interval |
 is_dst     | boolean  |
    

Documentation: pg_timezone_names

pg_timezone_names (PostgreSQL 9.0)

View "pg_catalog.pg_timezone_names"
   Column   |   Type   | Modifiers
------------+----------+-----------
 name       | text     |
 abbrev     | text     |
 utc_offset | interval |
 is_dst     | boolean  |
    

Documentation: pg_timezone_names

pg_timezone_names (PostgreSQL 8.4)

View "pg_catalog.pg_timezone_names"
   Column   |   Type   | Modifiers
------------+----------+-----------
 name       | text     |
 abbrev     | text     |
 utc_offset | interval |
 is_dst     | boolean  |
View definition:
 SELECT pg_timezone_names.name, pg_timezone_names.abbrev, pg_timezone_names.utc_offset, pg_timezone_names.is_dst
   FROM pg_timezone_names() pg_timezone_names(name, abbrev, utc_offset, is_dst);
    

Documentation: pg_timezone_names

pg_timezone_names (PostgreSQL 8.3)

View "pg_catalog.pg_timezone_names"
   Column   |   Type   | Modifiers
------------+----------+-----------
 name       | text     |
 abbrev     | text     |
 utc_offset | interval |
 is_dst     | boolean  |
View definition:
 SELECT pg_timezone_names.name, pg_timezone_names.abbrev, pg_timezone_names.utc_offset, pg_timezone_names.is_dst
   FROM pg_timezone_names() pg_timezone_names(name, abbrev, utc_offset, is_dst);
    

Documentation: pg_timezone_names

pg_timezone_names (PostgreSQL 8.2)

View "pg_catalog.pg_timezone_names"
   Column   |   Type   | Modifiers
------------+----------+-----------
 name       | text     |
 abbrev     | text     |
 utc_offset | interval |
 is_dst     | boolean  |
View definition:
 SELECT pg_timezone_names.name, pg_timezone_names.abbrev, pg_timezone_names.utc_offset, pg_timezone_names.is_dst
   FROM pg_timezone_names() pg_timezone_names(name, abbrev, utc_offset, is_dst);
    

Documentation: pg_timezone_names

Change history

This view has not been modified since it was first added.

Examples

postgres=# SELECT * FROM pg_timezone_names WHERE name like 'Europe/%' ORDER BY name LIMIT 15;
       name        | abbrev | utc_offset | is_dst
-------------------+--------+------------+--------
 Europe/Amsterdam  | CEST   | 02:00:00   | t
 Europe/Andorra    | CEST   | 02:00:00   | t
 Europe/Astrakhan  | +04    | 04:00:00   | f
 Europe/Athens     | EEST   | 03:00:00   | t
 Europe/Belfast    | BST    | 01:00:00   | t
 Europe/Belgrade   | CEST   | 02:00:00   | t
 Europe/Berlin     | CEST   | 02:00:00   | t
 Europe/Bratislava | CEST   | 02:00:00   | t
 Europe/Brussels   | CEST   | 02:00:00   | t
 Europe/Bucharest  | EEST   | 03:00:00   | t
 Europe/Budapest   | CEST   | 02:00:00   | t
 Europe/Busingen   | CEST   | 02:00:00   | t
 Europe/Chisinau   | EEST   | 03:00:00   | t
 Europe/Copenhagen | CEST   | 02:00:00   | t
 Europe/Dublin     | IST    | 01:00:00   | f
(15 rows)

Categories

System catalogue

See also

pg_timezone_abbrevs