PG Doc comments form <noreply@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