pg_timezone_names

The view pg_timezone_names provides a list of time zone names that are recognized by SET TIMEZONE, along with their associated abbreviations, UTC offsets, and daylight-savings status.

Reading PG 18current·documented in 21 of 24 versions, 8.2 to 20

7.4 8.0 8.1 8.2 8.3 8.4 9.0 9.1 9.2 9.3 9.4 9.5 9.6 10 11 12 13 14 15 16 17 18 19 20

Kind: System views
Columns in this snapshot: 4
Definition source: English manual
Metadata snapshot: 18.6

Columns 4

As listed in the PostgreSQL 18 manual.

Column	Type	Description / reference
`name`	`text`	Time zone name
`abbrev`	`text`	Time zone abbreviation
`utc_offset`	`interval`	Offset from UTC (positive means east of Greenwich)
`is_dst`	`bool`	True if currently observing daylight savings

Column history across versions

name

7.4 8.0 8.1 8.2 8.3 8.4 9.0 9.1 9.2 9.3 9.4 9.5 9.6 10 11 12 13 14 15 16 17 18 19 20

abbrev

7.4 8.0 8.1 8.2 8.3 8.4 9.0 9.1 9.2 9.3 9.4 9.5 9.6 10 11 12 13 14 15 16 17 18 19 20

utc_offset

7.4 8.0 8.1 8.2 8.3 8.4 9.0 9.1 9.2 9.3 9.4 9.5 9.6 10 11 12 13 14 15 16 17 18 19 20

is_dst

7.4 8.0 8.1 8.2 8.3 8.4 9.0 9.1 9.2 9.3 9.4 9.5 9.6 10 11 12 13 14 15 16 17 18 19 20

Version history 3

9.5 → 9.6 reworded
9.0 → 9.1 reworded
8.1 → 8.2 added

Definition snapshot: english-manuals:ea84334cdf945db8d26f95fecdf… · English manual source