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

1 vote136 views1 answer
Mysql login console
SQL
1 vote142 views3 answers
Getdate function in postgresql
SQL
6 votes159 views2 answers
Sql query to get the number of rows in a table
SQL
2 votes160 views1 answer
Oracle sql merge
SQL
1 vote157 views2 answers
Insert sqlite
SQL
2 votes181 views1 answer
Search query in mysql
SQL
0 vote151 views1 answer
Access denied for user 'root'@'localhost' (using password no) stackoverflow
SQL
0 vote169 views1 answer
What is default mysql database password in linux
SQL
0 vote150 views1 answer
Mysql create table like
SQL
1 vote141 views1 answer
How much every mysql database record takes from diskspace
SQL