Re: A generic trigger to log chanes on database tables

From: George Weaver <gweaver(at)shaw(dot)ca>
To: Charles Ambrose <jamjam360(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: A generic trigger to log chanes on database tables
Date: 2006-11-28 10:25:46
Message-ID: 003e01c712d7$9200e7f0$6400a8c0@Dell4500
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


----- Original Message -----
From: "Charles Ambrose" <jamjam360(at)gmail(dot)com>

> 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.

Charles,

You may want to check out the following (may also give you addtional ideas
for what you're trying to achieve):

http://www.varlena.com/GeneralBits/104.php
(Logging Audit Changes with Composite Typed Columns).

Regards,
George

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Terry Yapt 2006-11-28 10:59:06 [Windows] Pg_Restore on 8.1.5 and so on...
Previous Message Ragnar 2006-11-28 10:10:52 Re: sequence help