Time Zones

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

Query

SELECT name, abbrevFROM pg_timezone_names()ORDER BY name;

Result

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