timezone_abbreviations

A GUC specifying which time zone abbreviation collection to use

timezone_abbreviations is a configuration parameter specifying which time zone abbreviation collection to use.

timezone_abbreviations was added in PostgreSQL 8.2.

Usage

By default, a standard set of timezone abbreviations is used. timezone_abbreviations makes it possible to specify an alternative set of timezone abbreviations, in order to be able to use non-standard or regional variations.

Three standard sets are provided:

  • Default
  • Australia
  • India

Additional regional examples are located in the share/postgresql/timezonesets/ directory; these can be used as the basis for custom sets.

Default value

The default value for timezone_abbreviations is: Default

Change history

Examples

Example showing the effect of  for the timezone abbreviation EAST, which per standard IANA definition is the (obsolete) Easter Island Time, however in inofficial Australian usage is East Australian Standard Time:

postgres=# SHOW timezone_abbreviations ;
 timezone_abbreviations 
------------------------
 Default
(1 row)

postgres=# SELECT * FROM pg_timezone_abbrevs WHERE abbrev = 'EAST';
 abbrev | utc_offset | is_dst 
--------+------------+--------
 EAST   | -06:00:00  | f
(1 row)

postgres=# ALTER SYSTEM SET timezone_abbreviations TO 'Australia';
ALTER SYSTEM

postgres=# SELECT pg_reload_conf();
 pg_reload_conf 
----------------
 t
(1 row)

postgres=# SELECT * FROM pg_timezone_abbrevs WHERE abbrev = 'EAST';
 abbrev | utc_offset | is_dst 
--------+------------+--------
 EAST   | 10:00:00   | f
(1 row)

Categories

Date and time, GUC configuration item

See also

TimeZone, pg_timezone_abbrevs