That is a phenomenal article about timezones in general that apply to any database, as well as a great explanation of features specific to postgres.
It is interesting that a timestamp without timezone is internally represented a timestamptz at UTC.
Postgres is also has some great functionality converting between timezones:
https://www.postgresql.org/docs/11/functions-datetime.html#F...