DB record versioning/audit - Recommended Approach???

We do auditing in postgresql using triggers and a separate audit table
for each table. Much better solution IMO then trying to do it in the
application.