I implemented this using drizzle and PG not long ago

Check the repo here https://github.com/grmkris/drizzle-pg-notify-audit-table