temporal tables
pgext.cloud · Website · License text · Control file · PGXN
| Package | temporal_tables |
|---|---|
| Version | 1.2.2 |
| PostgreSQL versions | 14 · 15 · 16 · 17 · 18 |
| Repository | PIGSTY |
| Extension type | Standard |
| Requires CREATE EXTENSION | Yes |
| Requires preload | No |
| Trusted | No |
| Relocatable | Yes |
| Latest release | 2023-09-24 |
| Catalogue updated | 2026-07-29 |
| periods | Provide Standard SQL functionality for PERIODs and SYSTEM VERSIONING |
| table_version | PostgreSQL table versioning extension |
| data_historization | PLPGSQL Script to historize data in partitionned table |
| pgmemento | Transaction-based audit trail with schema versioning |
| table_log | record table modification logs and PITR for table/row |
| emaj | Enables fine-grained write logging and time travel on subsets of the database. |
| old_snapshot | utilities in support of old_snapshot_threshold |
| pg_dirtyread | Read dead but unvacuumed rows from table |
| pg_visibility | examine the visibility map (VM) and page-level visibility info |
| ddl_historization | Historize the ddl changes inside PostgreSQL database |