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?