Trigger function to audit any kind of table - Mailing list pgsql-general

From Sergio Duran
Subject Trigger function to audit any kind of table
Date
Msg-id c44353520606061154r242f63abrcba5c29a39891f3c@mail.gmail.com
Whole thread Raw
Responses Re: Trigger function to audit any kind of table
List pgsql-general
Hello,

I would like to know if it is possible to create a trigger function which does something like

CREATE OR REPLACE FUNCTION table_audit() RETURNS TRIGGER AS $table_audit$
BEGIN
  INSERT INTO audit SELECT TG_OP, current_timestampmp, current_user, OLD, NEW;
  RETURN NEW;
END $table_audit$ LANGUAGE plpgsql;

Can I create a table with those two RECORD pseudo-types or something compatible?

I'm using pgsql 8.1


Thanks.

pgsql-general by date:

Previous
From: John Sidney-Woollett
Date:
Subject: Re: Backwards index scan
Next
From: Andrew Sullivan
Date:
Subject: Re: Backwards index scan