https://www.codeproject.com/Articles/105768/Audit-Trail-Tracing-Data-Changes-in-Database
- https://wiki.postgresql.org/wiki/Audit_trigger_91plus
- the implementation uses hstore, if you want to use jsonb, check out https://github.com/razorlabs/pg-json-audit-trigger
- logical decoding
https://severalnines.com/database-blog/postgresql-audit-logging-best-practices https://www.cybertec-postgresql.com/en/row-change-auditing-options-for-postgresql/ https://github.com/pgMemento/pgMemento
-- Running this twice will produce the message 'pgMemento is already intialized for public schema.'; SELECT pgmemento.init('public');
-- Add individual tables. SELECT pgmemento.create_table_audit('table-name');