Postgres Pro
Downloads
Home   >   mailing lists

Re: alter table rename column can event trigger capture new column name - Mailing list pgsql-general

From jian he
Subject Re: alter table rename column can event trigger capture new column name
Date
Msg-id CACJufxFyK_H4CDz6hQX77bNiZchzd-VTveMuz19=ksDWszDO_A@mail.gmail.com
Whole thread Raw
List pgsql-general
Tree view


On Mon, Apr 24, 2023 at 10:46 AM jian he <jian.universality@gmail.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), '.')))

pgsql-general by date:

Previous
From: jian he
Date:
Subject: alter table rename column can event trigger capture new column name
Next
From: Garfield Lewis
Date:
Subject: Re: [EXT] Re: SCROLLABLE/UPDATABLE cursor question