1

I want to do a trigger in Postgres that it will update a log. My trigger will fire when an update, insert or delete is done.

CREATE TRIGGER tr_usuario
    BEFORE INSERT OR DELETE OR UPDATE 
    ON public.usuario
    FOR EACH ROW
    EXECUTE PROCEDURE public.actualizarlog();

Since my trigger is fired by any of these three actions, I can't know specifically what action triggered the trigger, but in my log also i want to save tha action that was performed. Is there any defined function in Postgres that let me know what action triggers a trigger?

Javier Martinez Barriga
  • 25
  • 4

1 Answers1

3

There's a special variable TG_OP which denotes the operation which caused the trigger to fire. It's a string reading INSERT, UPDATE, DELETE, or TRUNCATE respectively. See also: "42.10.1. Triggers on Data Changes"

sticky bit
  • 36,626
  • 12
  • 31
  • 42