Postgres list all triggers

select event_object_schema as table_schema,
       event_object_table as table_name,
       trigger_schema,
       trigger_name,
       string_agg(event_manipulation, ',') as event,
       action_timing as activation,
       action_condition as condition,
       action_statement as definition
from information_schema.triggers
group by 1,2,3,4,6,7,8
order by table_schema,
         table_name;

Similar codes

3 votes263 views2 answers
WhereIn SQL
SQL
2 votes279 views1 answer
Drop all database tables oracle sql developer
SQL
1 vote280 views1 answer
Rermove categories woocommerce sql
SQL
6 votes313 views1 answer
Oracle trigger after logon on database
SQL
0 vote270 views1 answer
Postgresql isnull with max
SQL
0 vote279 views1 answer
Oracle running queries sql
SQL
0 vote265 views1 answer
Xampp mysql version
SQL
0 vote278 views1 answer
Mysql Like(searching in the string)
SQL
0 vote297 views2 answers
Dbms transaction tutorialspoint
SQL
2 votes268 views1 answer
Oracle cpu per session
SQL