temporal_tables

PostgreSQL extension enabling time-travel queries and temporal table support

brewmacoslinux

Try with needOr install directly

About

Temporal Tables PostgreSQL Extension

psql

Enable temporal tables extension in PostgreSQL database$ psql -d mydb -c 'CREATE EXTENSION IF NOT EXISTS temporal_tables;'

Create a temporal table with versioning$ psql -d mydb -c 'CREATE TABLE employees (id INT, name TEXT, salary NUMERIC) INHERITS (temporal_tables);'

Query historical data from temporal table at specific timestamp$ psql -d mydb -c 'SELECT * FROM employees FOR SYSTEM_TIME AS OF timestamp;'