From: | Dev Kumkar <devdas(dot)kumkar(at)gmail(dot)com> |
---|---|
To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Timezone information |
Date: | 2014-02-19 14:19:19 |
Message-ID: | CALSLE1N0EtGip+YQRu=eSexN6wxWm_BX1nd29FTc9fGPuXKfEA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
How to set timezone in postgreSQL database to pick operating system level
timezone information.
In postgresql.conf there exists "timezone" parameter whose value can be set.
However this value needs to be in format 'US/Pacific', 'Asia/Calcutta' and
so on to work correctly.
Is there any database query to get operating system level timezone
information and then set accordingly.
Took a look into pg_timezone_names table and
SET [ SESSION | LOCAL ] TIME ZONE { timezone | LOCAL | DEFAULT }
When postgres is installed on IST timezone windows operating system,
registry key
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\TimeZoneInformation
has TimeZoneKeyName set as "India Standard Time". However post installation
postgresql.conf has timezone information set as 'Asia/Calcutta', is there
any binary which can be executed?
Regards...
From | Date | Subject | |
---|---|---|---|
Next Message | Merlin Moncure | 2014-02-19 14:38:00 | Re: why VARIADIC functions executed on array input? |
Previous Message | Tjibbe | 2014-02-19 14:17:44 | why VARIADIC functions executed on array input? |