Re: using pg's internal timezone database?

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: using pg's internal timezone database?
Date: 2011-12-20 12:29:15
Message-ID: CAOR=d=2qLkTC_MY_1cub8qgu3Qd7rh-d-PuCazL_Ku2NPP7g_g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Dec 20, 2011 at 2:05 AM, Louis-David Mitterrand
<vindex+lists-pgsql-general(at)apartia(dot)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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Greg Smith 2011-12-20 13:44:20 Re: fsync on ext4 does not work
Previous Message Daniel Migowski 2011-12-20 10:48:31 pg_restore should restore the schema comments and the database properties