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 vote197 views4 answers
Creating a comment and reply system PHP and MySQL
SQL
0 vote197 views1 answer
Const pool = mysql.createpool()
SQL
0 vote191 views1 answer
SELECT statement to find the specific cell in database table
SQL
10 votes175 views2 answers
Linux command line import mysql database
SQL
0 vote180 views2 answers
How to start postgresql laravel
SQL
0 vote190 views1 answer
Suse status MySQL
SQL
0 vote209 views1 answer
Distance calculator from lat long sql query
SQL
0 vote188 views1 answer
How many rows affected in sqllite
SQL
0 vote175 views1 answer
Data structures in sql
SQL
0 vote192 views1 answer
How to move a columns location in mysql
SQL