Home > mailing lists

Create event triger - Mailing list pgsql-general

From	Łukasz Jarych
Subject	Create event triger
Date	July 9, 2018 17:03:53
Msg-id	CAGv31od1ZSN9Zbu9Qu4F_51z96XETz1qVo7ehctsSrjD4uBhUA@mail.gmail.com Whole thread Raw
Responses	Re: Create event triger Re: Create event triger
List	pgsql-general

Hi,

i have small database and i am tracking changes using trigger:

CREATE TRIGGER t BEFORE INSERT OR UPDATE OR DELETE ON t_trig
       FOR EACH ROW EXECUTE PROCEDURE change_trigger();

It is possible to create general trigger for all tables?

Like event trigger?

It would be very helpful for me.

Now i have to set up this trigger on each table.

Best,

Jacek

From: Thomas Kellerer
Date: 09 July 2018, 16:29:44
Subject: Re: How to set array element to null value

From: Łukasz Jarych
Date: 09 July 2018, 17:38:16
Subject: Create DDL trigger to catch which column was altered