Updated on 2024-05-07 GMT+08:00

PG_TIMEZONE_ABBREVS

PG_TIMEZONE_ABBREVS displays information about all available time zones.

Table 1 PG_TIMEZONE_ABBREVS columns

Name

Type

Description

abbrev

text

Abbreviation of the time zone name.

utc_offset

interval

Offset from UTC.

is_dst

boolean

Specifies whether the DST is being used. If yes, the value is TRUE; otherwise, the value is FALSE.