Re: using pg's internal timezone database?

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: using pg's internal timezone database?
Дата
Msg-id CAOR=d=2qLkTC_MY_1cub8qgu3Qd7rh-d-PuCazL_Ku2NPP7g_g@mail.gmail.com
обсуждение исходный текст
Ответ на using pg's internal timezone database?  (Louis-David Mitterrand <vindex+lists-pgsql-general@apartia.org>)
Ответы Re: using pg's internal timezone database?
Список pgsql-general
On Tue, Dec 20, 2011 at 2:05 AM, Louis-David Mitterrand
<vindex+lists-pgsql-general@apartia.org> wrote:
> Hi,
>
> To provide my forum users with a 'timezeone' preference in their profile
> how can I use postgresql's internal table of timezones ?
>
> I found a reference to it here:
>
> http://www.postgresql.org/docs/7.2/static/timezones.html
>
> but not in recent versions docs.

You can view the pg internal tz database by looking at what's in the
tables pg_timezone_names and pg_timezone_abbrevs

-- To understand recursion, one must first understand recursion.

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

Предыдущее
От: Daniel Migowski
Дата:
Сообщение: pg_restore should restore the schema comments and the database properties
Следующее
От: Greg Smith
Дата:
Сообщение: Re: fsync on ext4 does not work