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 vote170 views1 answer
A network or instance-specific error sql server
SQL
0 vote143 views1 answer
Dump only data
SQL
0 vote138 views1 answer
How to count with except in psql
SQL
0 vote152 views2 answers
Oracle select
SQL
3 votes134 views1 answer
Postgresql if null then 0
SQL
5 votes181 views3 answers
Sql limit offset
SQL
0 vote177 views2 answers
Clauses in mysql
SQL
0 vote143 views1 answer
Work around for mutating problem in Oracle Triggers. Please check it out.
SQL
0 vote156 views1 answer
USING THE NOT CONDITION IN SQL
SQL
2 votes144 views1 answer
Datetrunc
SQL