Running PostgreSQL 7.2.1 on RedHat Linux 7.2.
I'm interested in turning on an audit trail
to note what tables have been updated, created,
selected from, who did it, what machine / connection
they're using, etc.
I saw something in the n.g. where something
similar has been done by a trigger and a
table with this info is kept.
I'm also sure this is yet another perfect time
to learn a new facet about PostgreSQL. So,
how do I create / manage an audit trail?
Thanks!
-X