pg-triggers

Triggers for postgres

language: also available in:

Install

$ psql < lib/recreate-his.sql
$ psql < lib/table-changes.sql
$ psql < lib/function-changes-trg.sql

Config

$ psql < lib/enance.sql
$ psql -c "select enance_table('state','country,state')"

You must call enance_table(table_name, primary_key_fields) for each table that you want to audit changes on each time you create a table or alter the primary key. By default the function will audit inserts, updates and deletes. But exists a third parameter method (optional). If this param receives the 'ud' value won't audit inserts (only will listen for updates and deletes)

Devel

$ npm install pg-triggers
$ npm test

License

MIT