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 vote490 views1 answer
Php insert null mysql
SQL
2 votes342 views1 answer
Error Code: 1055. Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column \\ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
0 vote368 views1 answer
R write csv without index
SQL
5 votes342 views1 answer
How to check port number for postgresql
SQL
0 vote442 views1 answer
Mysql get longest string in column
SQL
2 votes355 views1 answer
Oracle kill session by sql_id
SQL
57 votes555 views6 answers
Sql alter table
SQL
0 vote386 views1 answer
Local pg_sql to heroku pg_sql
SQL
3 votes347 views3 answers
Into in sql
SQL
10 votes391 views2 answers
Mysql remove only_full_group_by permanently
SQL