select open change scope Open full search

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

Extensions / Security

tablelog

Trigger-based audit and change-data-capture extension that records INSERT, UPDATE, and DELETE row images in a central log table and can generate replay SQL.

pgext.cloud · Source code · Documentation · Control file

Overview

Packagetablelog
Version0.1
PostgreSQL versions10 · 11 · 12 · 13 · 14 · 15 · 16 · 17 · 18
RepositoryUnspecified
Extension typeSQL only
Requires CREATE EXTENSIONYes
Requires preloadNo
TrustedNo
RelocatableYes
Stars2
Latest commit2019-02-12
Catalogue updated2026-08-30

Related extensions

Requires

plpgsqlPL/pgSQL procedural language
plv8PL/JavaScript (v8) trusted procedural language

See also

pgmementoTransaction-based audit trail with schema versioning
table_log_plPL/pgSQL drop-in replacement for the table_log trigger-based DML auditing extension.
table_logrecord table modification logs and PITR for table/row
cyanauditCyan Audit core extension
tcn_jsonC trigger function that sends primary-key change notifications through LISTEN/NOTIFY.
rppdTrigger-based PostgreSQL event dispatcher that sends row changes over gRPC to a clustered Rust/Python execution service.
auditAudits insert, update, and delete operations on PostgreSQL tables.
pg-audit-jsonTrigger-based PostgreSQL table auditing with JSONB row snapshots and recursive change diffs.
log_entriesRow trigger that records who changed a row and when
pgauditprovides auditing functionality