53.33. 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 or timezone_abbreviations run-time parameters are modified.

Tabela 53.33. pg_timezone_abbrevs Columns

Column Type

Description

abbrev text

Time zone abbreviation

utc_offset interval

Offset from UTC (positive means east of Greenwich)

is_dst bool

True if this is a daylight-savings abbreviation


While most timezone abbreviations represent fixed offsets from UTC, there are some that have historically varied in value (see Arquivos de configuração de data/hora for more information). In such cases this view presents their current meaning.