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 43-48. pg_timezone_abbrevs Columns
| Name | Type | Description |
|---|
| abbrev | text | Time zone abbreviation |
| utc_offset | interval | Offset from UTC (positive means east of Greenwich) |
| is_dst | boolean | True if this is a daylight-savings abbreviation |