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

0 vote374 views1 answer
PDOException: SQLSTATE[HY093]: Invalid parameter numb
SQL
18 votes362 views3 answers
Mysql add column with default value
SQL
1 vote328 views1 answer
Flask-sqlalchemy filter_by contains
SQL
1 vote345 views1 answer
Oracle sql assign unique number to each grouping
SQL
0 vote385 views1 answer
Data directory postgresql
SQL
2 votes368 views3 answers
Copy data from one table column to another table column in sql
SQL
0 vote353 views1 answer
Postgres full text search example
SQL
3 votes353 views3 answers
Your password does not satisfy the current policy requirements
SQL
0 vote355 views1 answer
Mysql find missing values
SQL
0 vote367 views1 answer
Mysql 5.6 hierarchical recursive query
SQL