Re: Timestamp Conversion Woes Redux - Mailing list pgsql-jdbc

Dave Cramer <pg@fastcrypt.com> writes:
> One issue I have is that the server returns some time zones in
> lowercase.

> ie EST -> est
>      EST5EDT -> est5edt

I think that in some contexts the case you will get back is what you
give in the SET command.  So do
    set timezone = 'EST5EDT';
not
    set timezone = EST5EDT;
(the latter is downcased as if it were an identifier).

            regards, tom lane