A simple, customisable table audit system for PostgreSQL implemented using triggers.
See:
http://wiki.postgresql.org/wiki/Audit_trigger_91plus
Run the following to get a list of tables to enable the logging on:
SELECT 'SELECT audit.audit_table(''' || table_name || ''');'
FROM information_schema.tables
WHERE table_schema = 'public'
ORDER BY table_name;