Re: Create trigger on after logon on schema

From: hubert depesz lubaczewski <depesz(at)depesz(dot)com>
To: aditya desai <admad123(at)gmail(dot)com>
Cc: pgsql-sql <pgsql-sql(at)lists(dot)postgresql(dot)org>
Subject: Re: Create trigger on after logon on schema
Date: 2021-10-06 15:44:44
Message-ID: 20211006154444.GB2265@depesz.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Wed, Oct 06, 2021 at 08:52:45PM +0530, aditya desai wrote:
> Hi,
> Is there any way to write below Oracle trigger in postgres?
>
> CREATE TRIGGER T1 after logon on schema for each row
> execute procedure p1;

What did it do?

Please note that not everyone knowing Pg knows Oracle.

I can imagine that trigger after logon means that p1 procedure will be
called after user successfully logs in, but what does the "for each row"
part mean?

In PG, there are no login triggers. And, in any case, noone logs to
"schema".

Best regards,

depesz

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message aditya desai 2021-10-06 16:09:28 Re: Create trigger on after logon on schema
Previous Message hubert depesz lubaczewski 2021-10-06 15:42:52 Re: DBMS Queus