audit-trigger
audit-trigger copied to clipboard
Simple, easily customised trigger-based auditing for PostgreSQL (Postgres). See also pgaudit.
Have some tables named with mixed-case (was there before I inherited). I saw the other ticket about tables in all uppercase, but looks like mixed case may mix it up...
Per the comment block this "Should really be converted into a relocatable EXTENSION, with control and upgrade files."
Now that I am using this particular sql code for audit-trigger, I would like to see which particular user is making changes in the table along with the the following...
Creating index on TG_RELID makes it small and neat to use but if I take a logical backup (pg_dump) of the DB and restore it on another server, the oid...
If a table you wish to audit has an hstore column the changes recorded in `changed_fields` is not tracking properly. consider a table with hstore column `hprops` with these initial...
The script was run and is operating normally. I want to make a query to return the structure: field | previous value | current value When the action is equal...
Our schema has a "user" table, user is also a reserved word in Postgres. When trying to enable auditing on this table, it throws an error. I've tried every vairation...
Postgresql vers.: 9.4 Table: vault_scanning.rolls The command : SELECT audit.audit_table('rolls'); completed with no errors. However, when I insert a new row, with pgAdmin III, into the 'rolls' table I get...