Implementing System Versioned Temporal Table - Surafel Temesgen: PGCon 2020
Channel: PGCon
Date: 2020-12-12

From https://www.pgcon.org/events/pgcon_2020/schedule/session/31-implementing-system-versioned-temporal-table/

SQL standard 2011 introduce a temporal table concept which describe a table that store data with respect to time instance. It has two part application time period table and system versioned temporal table.

An application time period are for meeting the requirements of applications based on application specific time periods which is valid in the business world rather than on the basis of the time it was entered in the database and system versioned temporal table state about the retention of old data alone with current data automatically by database management system and ability of queering both current and history data. A table can also be both a system versioned table and an application time period table.