This documentation is for an unsupported version of PostgreSQL.
You may want to view the same page for the
current
version, or one of the other supported versions listed above instead.
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 45-60. 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 |