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

From George Weaver
Subject Re: A generic trigger to log chanes on database tables
Date
Msg-id 003e01c712d7$9200e7f0$6400a8c0@Dell4500
Whole thread Raw
In response to A generic trigger to log chanes on database tables  ("Charles Ambrose" <jamjam360@gmail.com>)
List pgsql-general
----- Original Message -----
From: "Charles Ambrose" <jamjam360@gmail.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



pgsql-general by date:

Previous
From: Ragnar
Date:
Subject: Re: sequence help
Next
From: "Albe Laurenz"
Date:
Subject: Re: Question about encoding