PostgreSQL Audit Triggers

We have tables that might change regularly. We want to automate storing the changes to these tables, hence an audit table and an audit trigger. Based on Audit_trigger_91plus with some improvements from pg-audit-trigger.

How to use it

We currently have this set up in the gis schema. To see which tables are being logged SELECT * FROM gis.audited_tables_list.

To start logging a table run SELECT gis.audit_table('gis.table_name').

Any change to a tables' rows (INSERT, DELETE, UPDATE, TRUNCATE) will be stored in gis.logged_actions, including the timestamp of the action, the action, and the data stored before the operation.