logging table changes - Mailing list pgsql-novice

From Matthias Leopold
Subject logging table changes
Date
Msg-id 4C88AE8B.6060102@aic.at
Whole thread Raw
Responses Re: logging table changes  (Mladen Gogala <mgogala@vmsinfo.com>)
List pgsql-novice
hi,

how can i "easily" log changes to individual fields in a table without
naming these fields explicitly? i looked at the auditing example in
http://www.postgresql.org/docs/8.3/static/plpgsql-trigger.html, which
looks promising, but i can't think of a way to "easily" query the table
when i want to know when a certain field changed. i was thinking of
adding a field in the audit table which contains the names of all the
fields which changed, but i don't know who to "easily" get these names.
for some reason i think that there might already exist well known
solutions for my problem so i dare to ask here.

thx for advice

matthias

pgsql-novice by date:

Previous
From: Josh Kupershmidt
Date:
Subject: Re: Postgresql security checks
Next
From: "Rob Richardson"
Date:
Subject: Query help, please