Re: How do we get the Client-Time and Server-Time from psql ?

Thank you Very Much Steve.

On Thu, Jun 3, 2010 at 6:10 AM, Steve Crawford <
scrawford(at)pinpointresearch(dot)com> wrote:

> On 06/02/2010 03:29 PM, raghavendra t wrote:
>
>> ...
>>
>> Suppose am at the server-end, how could i get the client-time. Its really
>> troublesome when compared with the timezone column in a table.
>>
>> Not sure what you are getting at. You are always connected to the server
> _through_ a client and you _tell_ the server your timezone preferences.
>
> As long as you are using timestamptz and as long as the client properly
> sets its preferred time-zone prior to issuing queries or gives
> fully-qualified timestamps with TZ, then you are fine.
>
> Alternately, you can use (for libpq clients) the PGTZ environment variable.
>
> Or you can set things on a per-user basis:
> alter user foo set timezone to 'SOMETZ';
>
> Or for things like web-apps where the client-side of the connection to the
> database is probably through a single database-user and the actual users are
> all over the place you can set up a table of user-preferences and set the
> timezone appropriately.
>
> Cheers,
> Steve
>
>