Contents

pg_timezone_abbrevs

A system view providing a list of time zone abbreviations

pg_timezone_abbrevs is a system catalogue 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 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.

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)

Categories

System catalogue

See also

timezone_abbreviations, pg_timezone_names