Search Postgresql Archives

Re: using pg's internal timezone database?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxx> 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/* ?

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux