Re: A generic trigger to log chanes on database tables - Mailing list pgsql-general

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