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 vote198 views1 answer
Datetime postgres typeorm
SQL
2 votes204 views1 answer
Mariadb JSON_EXTRACT
SQL
3 votes187 views2 answers
Oracle sql select all days between two dates except weekends
SQL
0 vote191 views1 answer
How to define a save method in ruby for sql databases
SQL
12 votes236 views6 answers
Distinct in sql server
SQL
1 vote231 views1 answer
Psql human readable
SQL
0 vote168 views1 answer
Copy data from cell to cell mysql
SQL
0 vote264 views1 answer
Cartesian product sql
SQL
2 votes193 views1 answer
Mysql find tables with name
SQL
1 vote193 views1 answer
Funzioni plsql
SQL