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