On 2/19/2014 11:59 AM, Dev Kumkar wrote:
> Hmm. Is there any postgreSQL command/binary which can be used to set
> timezone according to OS one.
> At the time of postgreSQL install how does it pick timezone
> information and sets into postgreSQL.conf accordingly.
>
postgres handles timezones on a per client connection basis. the server
itself doesn't really care what timezone it is running in. 'timestamp
with time zone' data is internally stored in the equivalent of UTC, and
converted to/from the current client timezone on the fly (unless another
timezone is explicitly stated in the query).
--
john r pierce 37N 122W
somewhere on the middle of the left coast