Re: Time Zone Setting

On Fri, Jul 28, 2006 at 01:59:55PM -0700, James G Wilkinson wrote:
> I just ran into a small mystery.  I am trying to set the time zone
> during my session and here is what happens:

You can find the list of acceptable time zone names in Appendix B
of the documentation:

http://www.postgresql.org/docs/8.1/interactive/datetime-keywords.html#DATETIME-TIMEZONE-SET-TABLE

> My default timezone is PDT for this time of year.

Try 'PST8PDT' or 'US/Pacific'.

--
Michael Fuhr