System Catalogs / System views
pg_timezone_abbrevs
Read the PG 18 manualThe view pg_timezone_abbrevs provides a list of time zone abbreviations that are currently recognized by the datetime input routines.
Reading PG 18current·documented in 21 of 24 versions, 8.2 to 20
- Kind
- System views
- Columns in this snapshot
- 3
- Definition source
- English manual
- Metadata snapshot
- 18.6
Columns 3
As listed in the PostgreSQL 18 manual.
| Column | Type | Description / reference |
|---|---|---|
abbrev | text | Time zone abbreviation |
utc_offset | interval | Offset from UTC (positive means east of Greenwich) |
is_dst | bool | True if this is a daylight-savings abbreviation |
Column history across versions
Definition snapshot: english-manuals:08486bf32d72054ab3e11285616… · English manual source