Thomas Kellerer <spam_ea...@gmx.net> writes:
> is there any way (short of writing a function in an untrusted PL) to
> determine the actual time zone (or time) of the server OS?
The default value of the timezone parameter is as close as you'll get
in modern versions of PG.
> "show timezone" always returns the client's time zone.
AFAIK that would only be true if some part of your client stack
is issuing a SET TIMEZONE command. (libpq will do that if it finds
a PGTZ environment variable set, but not in response to plain TZ.)
If that's true, and you can't/don't want to change it, you could try
select reset_val from pg_settings where name = 'TimeZone';
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
