PG Doc comments form <nore...@postgresql.org> writes: > The documentation states that some timezone names are recognized. As far as > I understand others aren't.
There is more detail about that at https://www.postgresql.org/docs/current/datatype-datetime.html#DATATYPE-TIMEZONES Note in particular that time zone abbreviations are not considered valid values for the TimeZone setting. However, once you add a numeric offset, the string becomes a valid POSIX-style setting. regards, tom lane