Updated on 2023-10-31 GMT+08:00

PG_TIMEZONE_ABBREVS

PG_TIMEZONE_ABBREVS displays all time zone abbreviations that can be recognized by the input routines.

Table 1 PG_TIMEZONE_ABBREVS columns

Name

Type

Description

abbrev

text

Time zone abbreviation

utc_offset

interval

Offset from UTC

is_dst

boolean

Whether the abbreviation indicates a daylight saving time (DST) zone. If it does, its value is true. Otherwise, its value is false.