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