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 vote355 views4 answers
Creating a comment and reply system PHP and MySQL
SQL
1 vote270 views1 answer
Ms sql - add one hour to time
SQL
1 vote329 views2 answers
Drop table if exists test
SQL
0 vote352 views1 answer
Stored procedures example
SQL
0 vote325 views1 answer
Sql contains vs like
SQL
15 votes377 views3 answers
Mysql update add to existing value
SQL
0 vote328 views1 answer
Oracle create package specification
SQL
0 vote310 views1 answer
How do i calculate someone's age based on a datetime type birthday?
SQL
10 votes366 views2 answers
Mysql remove only_full_group_by permanently
SQL
1 vote337 views1 answer
Get all db sizes in mysql server
SQL