Time Zones

An up-to-date version of this list can be pulled from the pg_timezone_names() table function:

SQL

SELECT name, abbrevFROM pg_timezone_names()ORDER BY name;

 name                | abbrev
---------------------+---------
 Africa/Abidjan      | Iceland
 America/Los_Angeles | PST
 Europe/Berlin       | CET
 UTC                 | UTC