Catalogs: pg_timezone_abbrevs
48.71. pg_timezone_abbrevs
The view pg_timezone_abbrevs
provides a list of time zone abbreviations that are currently recognized by the datetime input routines. The contents of this view change when the timezone_abbreviations run-time parameter is modified.
Table 48-72. pg_timezone_abbrevs
Columns
Name | Type | Description |
---|---|---|
abbrev | text | Time zone abbreviation |
utc_offset | interval | Offset from UTC (positive means east of Greenwich) |