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 44-55. pg_timezone_abbrevs Columns
Name
Type
Description
abbrev
text
Time zone abbreviation
utc_offset
interval
Offset from UTC (positive means east of Greenwich)