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

1 vote358 views1 answer
Login to database mysql terminal
SQL
0 vote330 views1 answer
Postgres type equivalent to timespan c#
SQL
0 vote326 views1 answer
Codeigniter 3 get best-selling products
SQL
0 vote331 views3 answers
Sql drop all tables
SQL
22 votes334 views3 answers
Remove all records from table mysql
SQL
0 vote332 views1 answer
Sql string contains case sensitive
SQL
0 vote350 views1 answer
ORA-13717
SQL
6 votes329 views2 answers
Find mysql version linux
SQL
0 vote302 views1 answer
Check if a word appears at the end sql query
SQL
1 vote330 views1 answer
Mysql data from file
SQL