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