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: Create event triger
Date: 2018-07-09 11:03:53
Message-ID: CAGv31od1ZSN9Zbu9Qu4F_51z96XETz1qVo7ehctsSrjD4uBhUA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Łukasz Jarych 2018-07-09 11:38:16 Create DDL trigger to catch which column was altered
Previous Message Thomas Kellerer 2018-07-09 10:29:44 Re: How to set array element to null value