Updated on 2023-10-23 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

Whether DST is used. If DST is used, the value is true. Otherwise, the value is false.