Re: alter table rename column can event trigger capture new column name

From: jian he <jian(dot)universality(at)gmail(dot)com>
To: pgsql-general list <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: alter table rename column can event trigger capture new column name
Date: 2023-04-24 03:32:09
Message-ID: CACJufxFyK_H4CDz6hQX77bNiZchzd-VTveMuz19=ksDWszDO_A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Apr 24, 2023 at 10:46 AM jian he <jian(dot)universality(at)gmail(dot)com>
wrote:

>
> hi.
> alter table t1 rename col1 to id.
>
> Is it possible to use an event trigger to capture the new column name
> "id"?
>
>
>
sorry for the noise.
I figured it out.
substring(_object_identity FROM (LENGTH(_object_identity) + 2 -
STRPOS(REVERSE(_object_identity), '.')))

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Amit Kapila 2023-04-24 03:46:04 Re: Support logical replication of DDLs
Previous Message shaurya jain 2023-04-24 02:59:44 Re: Logical replication failed with SSL SYSCALL error