Re: Retrieve the server's time zone

Thomas Kellerer <spam_eater(at)gmx(dot)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