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.
Tabela 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 |