A simple approach 

• Postgres wiki: Audit trigger