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 vote357 views2 answers
Sql split string by space
SQL
1 vote330 views1 answer
Get rows affected mysql python
SQL
1 vote333 views1 answer
Postgres install unaccent extension
SQL
1 vote339 views1 answer
Set permanent SET GLOBAL sql_mode ubuntu
SQL
8 votes324 views2 answers
Mysql query dates between two dates
SQL
1 vote576 views1 answer
Postgres convert text to number
SQL
0 vote357 views1 answer
Mysql where in maintain order
SQL
0 vote361 views1 answer
Mysql remove last character
SQL
0 vote380 views2 answers
How to truncate all table in mysql workbench
SQL
0 vote322 views3 answers
ChAnge TABLE name apex oracle
SQL