select open change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Extensions / Time series

table_version

PostgreSQL table versioning extension

pgext.cloud · Source code · License text · Control file · PGXN

Overview

Packagetable_version
Version1.11.1
PostgreSQL versions14 · 15 · 16 · 17 · 18
RepositoryMultiple repositories
Extension typeStandard
Requires CREATE EXTENSIONYes
Requires preloadNo
TrustedNo
RelocatableNo
Schematable_version
Stars68
Latest commit2024-11-08
Latest release2024-11-08
Catalogue updated2026-08-30

Related extensions

Requires

plpgsqlPL/pgSQL procedural language

See also

data_historizationPLPGSQL Script to historize data in partitionned table
pgmementoTransaction-based audit trail with schema versioning
table_logrecord table modification logs and PITR for table/row
ddl_historizationHistorize the ddl changes inside PostgreSQL database
periodsProvide Standard SQL functionality for PERIODs and SYSTEM VERSIONING
temporal_tablestemporal tables
emajEnables fine-grained write logging and time travel on subsets of the database.
pgauditprovides auditing functionality
pg_drop_eventslogs transaction ids of drop table, drop column, drop materialized view statements
pgauditlogtofilepgAudit addon to redirect audit log to an independent file