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 vote173 views1 answer
How to execute stored output to csv files
SQL
4 votes174 views1 answer
Postgresql show current database
SQL
6 votes183 views3 answers
Can you update NULL in sql
SQL
4 votes178 views3 answers
Oracle sql first day of quarter
SQL
8 votes276 views1 answer
Insert a select statement into a table
SQL
0 vote183 views1 answer
18446744073709551615 mariadb left join order by
SQL
2 votes179 views1 answer
SELECT INTO
SQL
0 vote225 views1 answer
Mysql bind-address default value
SQL
0 vote210 views1 answer
How to print sql query
SQL
3 votes178 views2 answers
To_char oracle
SQL