PostgreSQL 8.2.6 Documentation
Prev Fast Backward Chapter 43. System Catalogs Fast Forward Next

43.48. 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 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
Prev Home Next
pg_tables Up pg_timezone_names