http://gborg.postgresql.org/project/tablelog/download/download.php
or http://gborg.postgresql.org/project/audittrail/download/download.php?branch=devel I haven't used either, but table_log seems to be one that I may start using in the near future. On Tue, 2003-06-24 at 13:17, Andrew Gould wrote: > I would like to create a audit log of update and > delete queries against a table. I want the log on the > server side, since access will be done using various > clients via ODBC. I would like to capture the user, > current datetime and the query statement. My thought > was to accomplish this by creating a rule that will > insert the information into a log table. > > How can I captures the query statement so that I can > place it in a insert query? Is there a variable in > the server that holds the query statement as a string? > > Am I about to go in over my head (again)? > > Thanks, > > Andrew > > ---------------------------(end of broadcast)--------------------------- > TIP 7: don't forget to increase your free space map settings -- Best Regards, Mike Benoit NetNation Communications Inc. Systems Engineer Tel: 604-684-6892 or 888-983-6600 --------------------------------------- Disclaimer: Opinions expressed here are my own and not necessarily those of my employer ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
