SL Baur <steve@beopen.com> writes:
> Oops. I didn't check carefully enough. Sorry.
>> steve=# set timezone='US/Pacific';
> That's incorrect syntax, it appears. Setting the timezone as `PST8PDT'
> or `:US/Pacific' works.
Looking at the code, it seems that 'set timezone' is implemented
directly as setting the TZ environment variable in the server.
So whatever timezone names are known to your local tzset() are the
ones that should work. I'd expect names like `PST8PDT' to be
pretty standard, other names less so...
regards, tom lane