Re: Create event triger

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Łukasz Jarych <jaryszek(at)gmail(dot)com>, guillaume(at)lelarge(dot)info
Cc: "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 13:56:20
Message-ID: 151c887a-d5b1-e8be-4ab6-0007f32895d4@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 07/10/2018 02:30 AM, Łukasz Jarych wrote:
> Maybe yes,
>
> but for me when i am learning it is not...

How do you do CREATE TABLE now, ad hoc in the client or via scripts?

If via scripts you could create a template script for the trigger and
then just fill in the table name as needed.

A function to add the trigger would be more involved and I do not have
the time at the moment to create an example. Will see if I can come up
with something later.

>
> Best,
> Jacek
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message a 2018-07-10 14:01:01 Re: Reporting bug on pgAdmin 4.3
Previous Message Adrian Klaver 2018-07-10 13:43:22 Re: Create DDL trigger to catch which column was altered