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

2 votes352 views1 answer
Drop all database tables oracle sql developer
SQL
3 votes354 views1 answer
Select database in sql
SQL
5 votes416 views3 answers
Create function in postgresql
SQL
0 vote306 views2 answers
How to combine two sql queries in one result
SQL
0 vote362 views1 answer
Cannot create a JSON value from a string with CHARACTER SET 'binary'.
SQL
0 vote364 views1 answer
Primary key multiple colums
SQL
0 vote383 views1 answer
Get last inserted primary key
SQL
2 votes359 views1 answer
Postgresql update sequence next value
SQL
10 votes370 views2 answers
SQL rounding numbers
SQL
12 votes351 views2 answers
Delete all entries postgres
SQL