Re: using pg's internal timezone database?

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(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

Hi,

Thanks for that info.

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