Re: Create event triger - Mailing list pgsql-general

2018-07-10 11:28 GMT+02:00 Łukasz Jarych <jaryszek@gmail.com>:

Thank you very much  Guillaume.

Do you know maybe any function to do it automatically? 

Nope, but it should be easy to write a shell script or a DO script to do it.

Best,

Jacek

wt., 10 lip 2018 o 11:25 Guillaume Lelarge <guillaume@lelarge.info> napisał(a):

2018-07-10 10:56 GMT+02:00 Łukasz Jarych <jaryszek@gmail.com>:

No possible?

Nope, you need to set up the trigger on each table.

Jacek

pon., 9 lip 2018 o 13:03 Łukasz Jarych <jaryszek@gmail.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 

--

Guillaume.

--

Guillaume.