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

25 votes158 views1 answer
How to update an attribute in MySQL
SQL
0 vote139 views1 answer
Mariadb cast null to 0
SQL
6 votes126 views4 answers
Mysql update set
SQL
0 vote131 views1 answer
Mysql set column equal to another automatic
SQL
0 vote132 views1 answer
Backup a table in sql
SQL
1 vote120 views1 answer
Oracle finding duplicate records
SQL
2 votes142 views4 answers
How to find 2nd highest salary in mysql
SQL
3 votes154 views2 answers
Mysql select database
SQL
103 votes347 views2 answers
Sql server LIKE '%%'
SQL
3 votes130 views2 answers
Current year sql
SQL