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

Поиск
Список
Период
Сортировка
От Merlin Moncure
Тема Re: Assign the system timezone to a variable in a function?
Дата
Msg-id BANLkTi=HqcJ9MGw11ST9AQ+Ydu21sacy8A@mail.gmail.com
обсуждение исходный текст
Ответ на Assign the system timezone to a variable in a function?  ("Steve Murphy" <smurphy@intorrent.com>)
Ответы Re: Assign the system timezone to a variable in a function?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-novice
On Tue, May 24, 2011 at 8:09 AM, Steve Murphy <smurphy@intorrent.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

В списке pgsql-novice по дате отправления:

Предыдущее
От: "Steve Murphy"
Дата:
Сообщение: Assign the system timezone to a variable in a function?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Assign the system timezone to a variable in a function?