Is there a way to set a different time zone as the default for a session?
By default, Postgres displays my data stored in "TIMESTAMP WITH TIME ZONE" columns' data as a local time for the time zone of the computer hosting the Postgres cluster.
If my Postgres server is in Seattle, but my user is in New York, I want the times shown in New York time zone.
I know about using the "AT TIME ZONE" command. But:
(a) I would rather set the time zone once in each database connection/session rather than include it in all my individual SQL calls.
(b) When using "TABLE myTable;" or "SELECT * FROM myTable;", I cannot specify "AT TIME ZONE".
--Basil Boruque