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 vote338 views1 answer
Delete from IN subquery
SQL
0 vote276 views1 answer
Download mysql database to excel in android studio
SQL
1 vote278 views1 answer
Apex run 404
SQL
0 vote271 views1 answer
Postgresql inline table
SQL
0 vote351 views1 answer
Compress sql file database ubuntu
SQL
0 vote231 views1 answer
Check id exist or not in sql
SQL
2 votes282 views1 answer
Postgresql drop primary key constraint
SQL
0 vote314 views1 answer
Exception message: The connection name 'SqlServices' was not found in the applications configuration or the connection string is empty.
SQL
0 vote294 views1 answer
Object of class mysqli_result could not be converted to string
SQL
1 vote277 views1 answer
Add constraint sql
SQL