Re: Create event triger

From: Łukasz Jarych <jaryszek(at)gmail(dot)com>
To: "pgsql-general(at)postgresql(dot)org >> PG-General Mailing List" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Create event triger
Date: 2018-07-10 08:56:52
Message-ID: CAGv31oeo6zZbqK4L+zJQWKgeBj3WWpY0X_fB-Q9RESsvWUVPiw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

No possible?

Jacek

pon., 9 lip 2018 o 13:03 Łukasz Jarych <jaryszek(at)gmail(dot)com> napisał(a):

> 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
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Guillaume Lelarge 2018-07-10 09:24:59 Re: Create event triger
Previous Message Łukasz Jarych 2018-07-10 08:56:14 Re: Create DDL trigger to catch which column was altered