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(at)nasby(dot)net
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)