Документация по PostgreSQL 8.2devel
PrevFast BackwardChapter 42. System CatalogsFast ForwardNext

42.48. pg_timezonenames

The view pg_timezonenames 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 42-48. pg_timezonenames Columns

NameTypeDescription
nametexttime zone abbreviation
utc_offsetintervaloffset from UTC (positive means east of Greenwich)
is_dstbooleantrue if this is a daylight-savings zone
PrevHomeNext
pg_tablesUppg_user