Skip to content

Latest commit

 

History

History
38 lines (28 loc) · 1.01 KB

README.md

File metadata and controls

38 lines (28 loc) · 1.01 KB

pg-triggers

Triggers for postgres

extending npm-version downloads

language: English also available in: Spanish

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.

Devel

$ npm install
$ psql --file install/create_db.sql
$ npm test

License

MIT