psql lst trigger

Solutions on MaxInterview for psql lst trigger by the best coders in the world

showing results for - "psql lst trigger"
Luca
18 Nov 2018
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