Trigger-based PostgreSQL table auditing with JSONB row snapshots and recursive change diffs.
pgext.cloud · Source code · Documentation · License text · Control file
| Package | pg-audit-json |
|---|---|
| Version | 1.0.2 |
| PostgreSQL versions | 10 · 11 · 12 · 13 · 14 · 15 · 16 · 17 · 18 |
| Repository | Unspecified |
| Extension type | SQL only |
| Requires CREATE EXTENSION | Yes |
| Requires preload | No |
| Trusted | No |
| Relocatable | No |
| Schema | audit |
| Stars | 47 |
| Latest commit | 2020-06-21 |
| Latest release | 2020-06-21 |
| Catalogue updated | 2026-08-30 |
| plpgsql | PL/pgSQL procedural language |
| pgmemento | Transaction-based audit trail with schema versioning |
| pgbson | BSON data type and accessor functions for PostgreSQL |
| supa_audit | Trigger-based table audit history with stable UUID record identities and JSONB row versions. |
| 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. |
| log_entries | Row trigger that records who changed a row and when |
| table_log_pl | PL/pgSQL drop-in replacement for the table_log trigger-based DML auditing extension. |
| pg_audit | An extension for creating audit tables |
| pgaudit | provides auditing functionality |