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 [email protected]
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