44.55. pg_timezone_abbrevs

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

NameTypeDescription
abbrevtextTime zone abbreviation
utc_offsetintervalOffset from UTC (positive means east of Greenwich)
is_dstbooleanTrue if this is a daylight-savings abbreviation

copyright  ©  August 29 2008 sean dreilinger url: http://durak.org/sean/pubs/software/postgresql/view-pg-timezone-abbrevs.html