Write an audit trigger to insert the required data into a table. I'm doing that myself for a table holding budget ledger data and will be creating the same concept for other tables.
Duane
-----Original Message-----
From: Daniel Devico [mailto:danico.info@free.fr]
Sent: Friday, June 11, 2004 2:25 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Keep history of modifications
Hye,
Is there a way to keep in a log file the history of all data changes (for
example keeping sql INSERT, DELETE or UPDATE) as would do dump, keeping
trace of the user who did it and when ?
Daniel
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match