default

PostgreSQL 8.2中增加了很多企业用户所需要的功能和性能上的提高,其开发团队说,该版本将加速更多企业向该数据库移植.核心开发成员之一Bruce Momjian表示,在新版PostgreSQL

# Time zone configuration file for set "Default"

# In order to use this file, you need to set the run-time parameter
# timezone_abbreviations to 'Default'.  See the `Date/Time Support'
# appendix in the PostgreSQL documentation for more information.
#
# $PostgreSQL: pgsql/src/timezone/tznames/Default,v 1.2.2.2 2008/01/02 21:42:09 tgl Exp $


#################### AFRICA ####################

EAT     10800    # East Africa Time
                 #     (Africa/Addis_Ababa)
                 #     (Africa/Asmera)
                 #     (Africa/Dar_es_Salaam)
                 #     (Africa/Djibouti)
                 #     (Africa/Kampala)
                 #     (Africa/Khartoum)
                 #     (Africa/Mogadishu)
                 #     (Africa/Nairobi)
                 #     (Indian/Antananarivo)
                 #     (Indian/Comoro)
                 #     (Indian/Mayotte)
WAT      3600    # West Africa Time
                 #     (Africa/Bangui)
                 #     (Africa/Brazzaville)
                 #     (Africa/Douala)
                 #     (Africa/Kinshasa)
                 #     (Africa/Lagos)
                 #     (Africa/Libreville)
                 #     (Africa/Luanda)
                 #     (Africa/Malabo)
                 #     (Africa/Ndjamena)
                 #     (Africa/Niamey)
                 #     (Africa/Porto-Novo)
                 #     (Africa/Windhoek)

#################### AMERICA ####################

# Acre time is sometimes called Acre Standard Time (AST) which leads to a
# conflict with AST (see below at AST)
ACT    -18000    # Acre Time
                 #     (America/Eirunepe)
                 #     (America/Rio_Branco)
ACST   -14400 D  # Acre Summer Time
                 #     (America/Eirunepe)
                 #     (America/Rio_Branco)
AKDT   -28800 D  # Alaska Daylight Time
                 #     (America/Anchorage)
                 #     (America/Juneau)
                 #     (America/Nome)
                 #     (America/Yakutat)
AKST   -32400    # Alaska Standard Time
                 #     (America/Anchorage)
                 #     (America/Juneau)
                 #     (America/Nome)
                 #     (America/Yakutat)
ART    -10800    # Argentina Time
                 #     (America/Argentina/Buenos_Aires)
                 #     (America/Argentina/Cordoba)
                 #     (America/Argentina/Tucuman)
                 #     (America/Argentina/La_Rioja)
                 #     (America/Argentina/San_Juan)
                 #     (America/Argentina/Jujuy)
                 #     (America/Argentina/Catamarca)
                 #     (America/Argentina/Mendoza)
                 #     (America/Argentina/Rio_Gallegos)
                 #     (America/Argentina/Ushuaia)
ARST    -7200 D  # Argentina Summer Time
BOT    -14400    # Bolivia Time
                 #     (America/La_Paz)
BRA    -10800    # Brazil Time (not in zic)
BRST    -7200 D  # Brasil Summer Time
                 #     (America/Sao_Paulo)
BRT    -10800    # Brasil Time
                 #     (America/Araguaina)
                 #     (America/Bahia)
                 #     (America/Belem)
                 #     (America/Fortaleza)
                 #     (America/Maceio)
                 #     (America/Recife)
                 #     (America/Sao_Paulo)
COT    -18000    # Columbia Time (not in zic)
# CONFLICT! CDT is not unique
# Other timezones:
#  - CDT: Mexico Central Daylight Time (America)
#  - CDT: Cuba Central Daylight Time (America)
#  - CDT: Canada Central Daylight Time (America)
CDT    -18000 D  # Central Daylight Time
                 #     (America/Cancun)
                 #     (America/Chicago)
                 #     (America/Menominee)
                 #     (America/Merida)
                 #     (America/Mexico_City)
                 #     (America/Monterrey)
                 #     (America/North_Dakota/Center)
                 #     (America/Rainy_River)
                 #     (America/Rankin_Inlet)
                 #     (America/Winnipeg)
CLST   -10800 D  # Chile Summer Time
                 #     (America/Santiago)
                 #     (Antarctica/Palmer)
CLT    -14400    # Chile Time
                 #     (America/Santiago)
                 #     (Antarctica/Palmer)
# CONFLICT! CST is not unique
# Other timezones:
#  - CST: Central Standard Time (Australia)
#  - CST: Cuba Central Standard Time (America)
CST    -21600    # Central Standard Time (America)
                 #     (America/Cancun)
                 #     (America/Chicago)
                 #     (America/Menominee)
                 #     (America/Merida)
                 #     (America/Mexico_City)
                 #     (America/Monterrey)
                 #     (America/North_Dakota/Center)
                 #     (America/Rainy_River)
                 #     (America/Rankin_Inlet)
                 #     (America/Regina)
                 #     (America/Swift_Current)
                 #     (America/Winnipeg)
EDT    -14400 D  # Eastern Daylight Saving Time
                 #     (America/Detroit)
                 #     (America/Grand_Turk)
                 #     (America/Indiana/Indianapolis)
                 #     (America/Indiana/Knox)
                 #     (America/Indiana/Marengo)
                 #     (America/Indiana/Vevay)
                 #     (America/Iqaluit)
                 #     (America/Kentucky/Louisville)
                 #     (America/Kentucky/Monticello)
                 #     (America/Montreal)
                 #     (America/Nassau)
                 #     (America/New_York)
                 #     (America/Nipigon)
                 #     (America/Pangnirtung)
                 #     (America/Thunder_Bay)
                 #     (America/Toronto)
EGST        0 D  # East Greenland Summer Time
                 #     (America/Scoresbysund)
EGT     -3600    # East Greenland Time (Svalbard & Jan Mayen)
                 #     (America/Scoresbysund)
# CONFLICT! EST is not unique
# Other timezones:
#  - EST: Eastern Standard Time (Australia)
EST    -18000    # Eastern Standard Time (America)
                 #     (America/Cayman)
                 #     (America/Coral_Harbour)
                 #     (America/Detroit)
                 #     (America/Grand_Turk)
                 #     (America/Indiana/Indianapolis)
                 #     (America/Indiana/Knox)
                 #     (America/Indiana/Marengo)
                 #     (America/Indiana/Vevay)
                 #     (America/Iqaluit)
                 #     (America/Jamaica)
                 #     (America/Kentucky/Louisville)
                 #     (America/Kentucky/Monticello)
                 #     (America/Montreal)
                 #     (America/Nassau)
                 #     (America/New_York)
                 #     (America/Nipigon)
                 #     (America/Panama)
                 #     (America/Pangnirtung)
                 #     (America/Thunder_Bay)
                 #     (America/Toronto)
FNT     -7200    # Fernando de Noronha Time
                 #     (America/Noronha)
FNST    -3600 D  # Fernando de Noronha Summer Time (not in zic)
                 #     (America/Noronha)
GFT    -10800    # French Guiana Time
                 #     (America/Cayenne)
GYT    -14400    # Guyana Time
                 #     (America/Guyana)
MDT    -21600 D  # Mexico Mountain Daylight Time
                 # Mountain Daylight Time
                 #     (America/Boise)
                 #     (America/Cambridge_Bay)
                 #     (America/Chihuahua)
                 #     (America/Denver)
                 #     (America/Edmonton)
                 #     (America/Inuvik)
                 #     (America/Mazatlan)
                 #     (America/Yellowknife)
MST    -25200    # Mexico Mountain Standard Time
                 # Mountain Standard Time
                 #     (America/Boise)
                 #     (America/Cambridge_Bay)
                 #     (America/Chihuahua)
                 #     (America/Dawson_Creek)
                 #     (America/Denver)
                 #     (America/Edmonton)
                 #     (America/Hermosillo)
                 #     (America/Inuvik)
                 #     (America/Mazatlan)
                 #     (America/Phoenix)
                 #     (America/Yellowknife)
NDT     -9000 D  # Newfoundland Daylight Time
                 #     (America/St_Johns)
NST    -12600    # Newfoundland Standard Time
                 #     (America/St_Johns)
PET    -18000    # Peru Time (not in zic)
PDT    -25200 D  # Pacific Daylight Time
                 #     (America/Dawson)
                 #     (America/Los_Angeles)
                 #     (America/Tijuana)
                 #     (America/Vancouver)
                 #     (America/Whitehorse)
PMDT    -7200 D  # Pierre & Miquelon Daylight Time
                 #     (America/Miquelon)
PMST   -10800    # Pierre & Miquelon Standard Time
                 #     (America/Miquelon)
PST    -28800    # Pacific Standard Time
                 #     (America/Dawson)
                 #     (America/Los_Angeles)
                 #     (America/Tijuana)
                 #     (America/Vancouver)
                 #     (America/Whitehorse)
                 #     (Pacific/Pitcairn)
PYST   -10800 D  # Paraguay Summer Time
                 #     (America/Asuncion)
PYT    -14400    # Paraguay Time
                 #     (America/Asuncion)
UYST    -7200 D  # Uruguay Summer Time (not in zic)
UYT    -10800    # Uruguay Time (not in zic)
VET    -14400    # Venezuela Time
                 #     (America/Caracas)
WGST    -7200 D  # Western Greenland Summer Time
                 #     (America/Godthab)
WGT    -10800    # West Greenland Time
                 #     (America/Godthab)

#################### ANTARCTICA ####################

DAVT    25200    # Davis Time (Antarctica)
                 #     (Antarctica/Davis)
DDUT    36000    # Dumont-d'Urville Time (Antarctica)
                 #     (Antarctica/DumontDUrville)
                 #     (Antarctica/Palmer)
                 #     (America/Santiago)
MAWT    21600    # Mawson Time (Antarctica)
                 #     (Antarctica/Mawson)

#################### ASIA ####################

AFT     16200    # Afghanistan Time
                 #     (Asia/Kabul)
ALMT    21600    # Alma-Ata Time
                 #     (Asia/Almaty)
ALMST   25200 D  # Alma-Ata Summer Time
                 #     (Asia/Almaty)
AMST    18000 D  # Armenia Summer Time
                 #     (Asia/Yerevan)
# CONFLICT! AMT is not unique
# Other timezones:
#  - AMT: Amazon Time (America)
AMT     14400    # Armenia Time
                 #     (Asia/Yerevan)
ANAST   46800 D  # Anadyr Summer Time
                 #     (Asia/Anadyr)
ANAT    43200    # Anadyr Time
                 #     (Asia/Anadyr)
AZST    18000 D  # Azerbaijan Summer Time
                 #     (Asia/Baku)
AZT     14400    # Azerbaijan Time
                 #     (Asia/Baku)
BDT     21600    # Bangladesh Time
                 #     (Asia/Dhaka)
BNT     28800    # Brunei Darussalam Time
                 #     (Asia/Brunei)
BORT    28800    # Borneo Time (Indonesia) (not in zic)
BTT     21600    # Bhutan Time
                 #     (Asia/Thimphu)
CCT     28800    # China Coastal Time (not in zic)
GEST    14400 D  # Georgia Summer Time (there was a timezone change in 2004)
                 #     (Asia/Tbilisi)
GET     10800    # Georgia Time (there was a timezone change in 2004)
                 #     (Asia/Tbilisi)
HKT     28800    # Hong Kong Time (not in zic)
ICT     25200    # Indochina Time
                 #     (Asia/Bangkok)
                 #     (Asia/Phnom_Penh)
                 #     (Asia/Saigon)
                 #     (Asia/Vientiane)
IRKST   32400 D  # Irkutsk Summer Time
                 #     (Asia/Irkutsk)
IRKT    28800    # Irkutsk Time
                 #     (Asia/Irkutsk)
IRT     12600    # Iran Time (not in zic)
# CONFLICT! IST is not unique
# Other timezones:
# - IST: Irish Summer Time (Europe)
# - IST: Indian Standard Time (Asia)
IST      7200    # Israel Standard Time (not in zic)
JAYT    32400    # Jayapura Time (Indonesia) (not in zic)
JST     32400    # Japan Standard Time
                 #     (Asia/Tokyo)
KDT     36000 D  # Korean Daylight Time (not in zic)
KGST    21600 D  # Kyrgyzstan Summer Time
                 #     (Asia/Bishkek)
KGT     18000    # Kyrgyzstan Time
                 #     (Asia/Bishkek)
KRAST   28800 D  # Krasnoyarsk Summer Time
                 #     (Asia/Krasnoyarsk)
KRAT    25200    # Krasnoyarsk Time
                 #     (Asia/Krasnoyarsk)
KST     32400    # Korean Standard Time
                 #     (Asia/Pyongyang)
LKT     21600    # Lanka Time
                 #     (Asia/Colombo)
MAGST   43200 D  # Magadan Summer Time
                 #     (Asia/Magadan)
MAGT    39600    # Magadan Time
                 #     (Asia/Magadan)
MMT     23400    # Myanmar Time
                 #     (Asia/Rangoon)
MYT     28800    # Malaysia Time
                 #     (Asia/Kuala_Lumpur)
                 #     (Asia/Kuching)
NOVST   25200 D  # Novosibirsk Summer Time
                 #     (Asia/Novosibirsk)
NOVT    21600    # Novosibirsk Time
                 #     (Asia/Novosibirsk)
NPT     20700    # Nepal Time
                 #     (Asia/Katmandu)
OMSST   25200 D  # Omsk Summer Time
                 #     (Asia/Omsk)
OMST    21600    # Omsk Time
                 #     (Asia/Omsk)
PETST   46800 D  # Petropavlovsk-Kamchatski Summer Time
                 #     (Asia/Kamchatka)
PETT    43200    # Petropavlovsk-Kamchatski Time
                 #     (Asia/Kamchatka)
PHT     28800    # Phillipine Time (not in zic)
PKT     18000    # Pakistan Time (not in zic)
TJT     18000    # Tajikistan Time
                 #     (Asia/Dushanbe)
TMT     18000    # Turkmenistan Time
                 #     (Asia/Ashgabat)
ULAST   32400 D  # Ulan Bator Summer Time
                 #     (Asia/Ulaanbaatar)
ULAT    28800    # Ulan Bator Time
                 #     (Asia/Ulaanbaatar)
UZST    21600 D  # Uzbekistan Summer Time
                 #     (Asia/Samarkand)
                 #     (Asia/Tashkent)
UZT     18000    # Uzbekistan Time
                 #     (Asia/Samarkand)
                 #     (Asia/Tashkent)
VLAST   39600 D  # Vladivostok Summer Time
                 #     (Asia/Vladivostok)
VLAT    36000    # Vladivostok Time
                 #     (Asia/Vladivostok)
YAKST   36000 D  # Yakutsk Summer Time
                 #     (Asia/Yakutsk)
YAKT    32400    # Yakutsk Time
                 #     (Asia/Yakutsk)
YEKST   21600 D  # Yekaterinburg Summer Time