pg_timezone_names — PostgreSQL system view

The PostgreSQL pg_timezone_names system view: full column reference (names, types, descriptions), catalog relationships and version support.

The Sev-1 Admin
The Sev-1 Admin  ·  1 min read

Summary

The view pg_timezone_names provides a list of time zone names that are recognized by SET TIMEZONE, along with their associated abbreviations, UTC offsets, and daylight-savings status. (Technically, PostgreSQL does not use UTC because leap seconds are not handled.) Unlike the abbreviations shown in pg_timezone_abbrevs, many of these names imply a set of daylight-savings transition date rules. Therefore, the associated information changes across local DST boundaries. The displayed information is computed based on the current value of CURRENT_TIMESTAMP.

(Description quoted from the official PostgreSQL documentation.)

Columns

The pg_timezone_names system view exposes the following columns (names, types and descriptions are taken verbatim from the PostgreSQL documentation):

  • name text
    Time zone name
  • abbrev text
    Time zone abbreviation
  • utc_offset interval
    Offset from UTC (positive means east of Greenwich)
  • is_dst bool
    True if currently observing daylight savings

Version applicability

Present in PostgreSQL 17, 18, 19 (verified against each release’s documentation). This is a long-standing system object that also exists in earlier PostgreSQL releases.

Related & references

Reference: PostgreSQL documentation — pg_timezone_names.