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 |