select open change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

SYSTEM CATALOGS / SYSTEM VIEWS

pg_timezone_abbrevs

Read PG 18 manual ↗

The view pg_timezone_abbrevs provides a list of time zone abbreviations that are currently recognized by the datetime input routines.

Kind
System views
Columns in this snapshot
3
Definition source
English manual

Columns 3

ColumnTypeDescription / reference
abbrevtextTime zone abbreviation
utc_offsetintervalOffset from UTC (positive means east of Greenwich)
is_dstboolTrue if this is a daylight-savings abbreviation
Column history across versions
Version history 1
  1. PG 17 → 18changed

Definition snapshot: english-manuals:735f4a138a72c3531959eec568d… · English manual source