Psql lst trigger

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;
Code has been copied

Source: dataedo.com

Similar codes

0 vote120 views1 answer
Mysql database is not starting in xampp
SQL
0 vote154 views1 answer
Update database collation in postgresql
SQL
0 vote124 views1 answer
LoadError: cannot load such file -- mysql2/2.7/mysql2
SQL
4 votes131 views4 answers
Start mysql
SQL
1 vote120 views1 answer
Floor function in sql oracle
SQL
0 vote157 views1 answer
Mysql join only one column
SQL
0 vote148 views1 answer
Sql server insert inner join
SQL
0 vote132 views1 answer
Xampp increame mysql speed
SQL
0 vote143 views1 answer
Sql combine results from two tables
SQL
33 votes135 views6 answers
Sql delete
SQL