Skip site navigation (1) Skip section navigation (2)

Re: Assign the system timezone to a variable in a function?

From: Merlin Moncure <mmoncure(at)gmail(dot)com>
To: Steve Murphy <smurphy(at)intorrent(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Assign the system timezone to a variable in a function?
Date: 2011-05-24 13:43:23
Message-ID: BANLkTi=HqcJ9MGw11ST9AQ+Ydu21sacy8A@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
On Tue, May 24, 2011 at 8:09 AM, Steve Murphy <smurphy(at)intorrent(dot)com> wrote:
> I have read the docs twice; I have tried all sorts of things;
>
> there must be some way to do this simple thing:
>
>
>
> Take the result of "show timezone", and assign it to a variable
>
> in a function.

I was about to suggest querying the pg_settings table, then noticed
there was no 'timezone' record in it, which is pretty odd imo.  You
can look at the log_timezone record however, which might be correct.

merlin

In response to

Responses

pgsql-novice by date

Next:From: Tom LaneDate: 2011-05-24 13:49:20
Subject: Re: Assign the system timezone to a variable in a function?
Previous:From: Steve MurphyDate: 2011-05-24 13:09:07
Subject: Assign the system timezone to a variable in a function?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group