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.

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

Columns 4

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

Column	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
`name`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`abbrev`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`utc_offset`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`is_dst`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●

Version history 2

PG 9.5 → 9.6changed
PG 9.0 → 9.1changed

Definition snapshot: english-manuals:470f8490fec8e4586af3409ca27… · English manual source