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 vote125 views1 answer
SqlMessage: "Table 'Friends' already exists",
SQL
39 votes208 views5 answers
Sql drop column
SQL
1 vote113 views1 answer
Oracle case
SQL
0 vote121 views1 answer
Create database like
SQL
22 votes200 views4 answers
Tsql rename table
SQL
2 votes123 views4 answers
Sql query interview questions
SQL
0 vote109 views1 answer
Bus source and destination equal to destination and source of another by sql query
SQL
0 vote104 views1 answer
Oracle create job if not exists
SQL
1 vote116 views1 answer
Sql server list locks
SQL
0 vote103 views2 answers
How to delete the rows with null values in mysql
SQL