Обсуждение: Re: alter table rename column can event trigger capture new column name

Поиск
Список
Период
Сортировка

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

От
jian he
Дата:


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), '.')))