Re: Create event triger

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Create event triger
Date: 2018-07-10 10:05:09
Message-ID: 0a67f47e-947f-4de1-34d4-ffe4813cc0d9@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Duarte Carreira 2018-07-10 10:30:38 Re: correcting tablespaces inside data folder
Previous Message Łukasz Jarych 2018-07-10 09:30:18 Re: Create event triger