Postgres Pro
Downloads
Home   >   mailing lists

Re: Regarding timezone - Mailing list pgsql-general

From Dev Kumkar
Subject Re: Regarding timezone
Date
Msg-id CALSLE1PqH5+6eQUCSYtFwov7xWi3i4OqFrLWJYQhH9PwrBCsdg@mail.gmail.com
Whole thread Raw
In response to Re: Regarding timezone  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: Regarding timezone  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Tree view
On Wed, Sep 17, 2014 at 7:24 PM, Adrian Klaver <adrian.klaver@aklaver.com> wrote:
So you will need to determine what method you binaries use. If they are using the system timezone data, you will need to update that.

Thanks!

Just a hack here, how about copying "pgsql/share/postgresql/timezone/Etc/GMT-3" as "pgsql/share/postgresql/timezone/Europe/Moscow"
This will make the pg_timezone_names() function to return output as follows:
>> "Europe/Moscow";"GMT-3";"03:00:00";f

With this "now()" function returns expected data for Moscow timezone.
Please let me know your comments here.

Regards..

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: encoding confusion with \copy command
Next
From: Dev Kumkar
Date:
Subject: Re: [SQL] pg_multixact issues