Recording SELECT statements in PostgreSQL 8.4
- by David Anniwell
Hi All
I've got a table which contains sensitive data and according to data protection policy we have to keep a record of every read/write of the data including a row identifier and the user who accessed the table. The writing is no issue using triggers but obviously triggers aren't supported for SELECT statements.
What's the best method of doing…