PLPGSQL Script to historize data in partitionned table
pgext.cloud · Source code · Control file · PGXN
| Package | data_historization |
|---|---|
| Version | 1.1.0 |
| PostgreSQL versions | 14 · 15 · 16 · 17 · 18 |
| Repository | PIGSTY |
| Extension type | SQL only |
| Requires CREATE EXTENSION | Yes |
| Requires preload | No |
| Trusted | Yes |
| Relocatable | No |
| Stars | 1 |
| Latest commit | 2024-12-17 |
| Latest release | 2024-12-17 |
| Catalogue updated | 2026-08-30 |
| plpgsql | PL/pgSQL procedural language |
| table_log | record table modification logs and PITR for table/row |
| pgmemento | Transaction-based audit trail with schema versioning |
| table_version | PostgreSQL table versioning extension |
| temporal_tables | temporal tables |
| periods | Provide Standard SQL functionality for PERIODs and SYSTEM VERSIONING |
| ddl_historization | Historize the ddl changes inside PostgreSQL database |
| emaj | Enables fine-grained write logging and time travel on subsets of the database. |
| pgaudit | provides auditing functionality |
| pg_drop_events | logs transaction ids of drop table, drop column, drop materialized view statements |
| pgauditlogtofile | pgAudit addon to redirect audit log to an independent file |