Re: Keep history of modifications

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(dot)info(at)free(dot)fr]
Sent: Friday, June 11, 2004 2:25 AM
To: pgsql-general(at)postgresql(dot)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