Implementing System-Versioned Tables in Postgres
I like Postgres, but there are things I really wish they would implement. For
example, the SQL:2011 spec adds
support for system-versioned tables. Unfortunately, Postgres and SQLite are
basically the only SQL databases that don’t yet support it. While it has been
discussed in length at the postgreqsl-hackers’ mailing
list,
it seems like the discussion and implementation efforts have been silent in all
of 2023.
Now, there are extensions out there that implement versioning –
temporal_tables
being ...
Read more at hypirion.com