On Nov 23, 2006, at 10:32 AM, Charles Ambrose wrote:
Is there a way that I could create a trigger that logs the changes (updates, deletes) of a table? I mean, I want to put in a table the changes to any table in a database and also put in the table the column that was modified and the corresponding value.
If you want a table-generic method, look at how Slony does it. You probably won't want to use exactly that code, but it should get you close.
-- Jim Nasby jim@xxxxxxxxx EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)