1select event_object_schema as table_schema,
2 event_object_table as table_name,
3 trigger_schema,
4 trigger_name,
5 string_agg(event_manipulation, ',') as event,
6 action_timing as activation,
7 action_condition as condition,
8 action_statement as definition
9from information_schema.triggers
10group by 1,2,3,4,6,7,8
11order by table_schema,
12 table_name;
13Code has been copied