pg_timezone_names
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.
Definition by PostgreSQL version
pg_timezone_names (PostgreSQL 15)
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 14)
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 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.
- PostgreSQL 8.2
- added (commit d8b5c95c)
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)
References
- PostgreSQL documentation: pg_timezone_names