Re: Create event triger - Mailing list pgsql-general

From Thomas Kellerer
Subject Re: Create event triger
Date
Msg-id 0a67f47e-947f-4de1-34d4-ffe4813cc0d9@gmx.net
Whole thread Raw
In response to Create event triger  (Łukasz Jarych <jaryszek@gmail.com>)
List pgsql-general
Łukasz Jarych schrieb am 09.07.2018 um 13:03:
> 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.

Maybe pgaudit is a better solution? 

https://www.pgaudit.org/



pgsql-general by date:

Previous
From: Łukasz Jarych
Date:
Subject: Re: Create event triger
Next
From: Duarte Carreira
Date:
Subject: Re: correcting tablespaces inside data folder