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

Reply via email to