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

3 votes220 views1 answer
RENAME table pl sql
SQL
0 vote224 views1 answer
Uncaught Error: Call to undefined function DatabaseOld\mysqli_connect()
SQL
0 vote217 views1 answer
Sql set data from a select query to a temp table and insert
SQL
8 votes216 views1 answer
How to check mysql version in xampp
SQL
0 vote215 views1 answer
Start and stop mysql
SQL
1 vote225 views1 answer
Sql first day quarter
SQL
0 vote225 views2 answers
What is the default password for sql server sa
SQL
2 votes223 views1 answer
Scaffold npgsql net core
SQL
1 vote230 views1 answer
Oracle select row max date
SQL
0 vote213 views1 answer
Sqlite closes value
SQL