Thread: using pg's internal timezone database?

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.

Thanks,

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.

On Tue, Dec 20, 2011 at 05:29:15AM -0700, Scott Marlowe wrote:
> 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

Hi,

Thanks for that info.

There are 1146 timezones listed in that table! Which sublist is the most
commonly used or standard? posix/* ?