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 vote176 views1 answer
Error code 1241 mysql
SQL
1 vote171 views1 answer
Md5 encryption for existing records
SQL
7 votes168 views1 answer
Connect mysql docker
SQL
2 votes191 views1 answer
Sql finding longest and shortest names in a fleld
SQL
1 vote168 views4 answers
Between vs in sql
SQL
0 vote189 views1 answer
Why do we need data structure in sql
SQL
0 vote212 views1 answer
How to subquey to do not load in live database in
SQL
2 votes177 views1 answer
Flask sqlalchemy boolean field
SQL
0 vote169 views2 answers
How to generate a unique random number in mysql
SQL
0 vote190 views1 answer
Check command
SQL