Re: Create event triger

select add_trigger('trg_test');

test=> \d trg_test

                    Table "public.trg_test"


  Column |       Type        | Collation | Nullable | Default


--------+-------------------+-----------+----------+---------


  id     | integer           |           |          |


  fld_1  | character varying |           |          |


Triggers:


     trg_test_change AFTER UPDATE ON trg_test FOR EACH STATEMENT EXECUTE
PROCEDURE ts_update()

SELECT table_name,add_trigger(table_name) FROM information_schema.tables WHERE table_schema='public';

SELECT table_name FROM information_schema.tables WHERE table_schema='public';