Re: Field collection in trigger

Josué Maldonado <josue@lamundial.hn> writes:

> Hello list,
>
> First of all, excuse me if this is not the right place to ask my question.
>
> Is there a way in postgresql to loop to all the fields of a  given
> table and compare the OLD and NEW value for each field. I need to make
> an audit table that must contain only the fields changed after and
> insert/update.

You should be able to do this in a Perl or C trigger.  It can't be
done in PL/pgSQL without writing a custom trigger for each table that
hard-codes all the field names.

-Doug