pg-triggers

0.3.3 • Public • Published

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

/pg-triggers/

    Package Sidebar

    Install

    npm i pg-triggers

    Weekly Downloads

    95

    Version

    0.3.3

    License

    MIT

    Unpacked Size

    7.18 kB

    Total Files

    8

    Last publish

    Collaborators

    • tute