On Tue, 2021-09-21 at 19:35 +1200, Tim Uckun wrote:
> It seems like it would be so much more useful if the timestamp with
> time zone type actually stored the time zone in the record.
This has been requested before, and it would be closer to the intention
of the SQL standard, but I guess it won't happen.
For one, it would change on-disk storage, which would make it
impossible to use pg_upgrade. It also would require timestamps to
occupy more than 8 bytes.
The best solution is probably to explicitly store the time zone as
an additional column.
Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com