Tom Lane schrieb am 14.11.2017 um 15:36:
>> 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?
>
> AFAIK that would only be true if some part of your client stack
> is issuing a SET TIMEZONE command. (libpq will do
Thomas Kellerer 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"
Hello,
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?
"show timezone" always returns the client's time zone.
localtimestamp also converts the server's time to the client time zone (the one
defined by