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 vote172 views1 answer
Find how many tables in database sql query
SQL
0 vote161 views2 answers
Sql trigger difference between for and after
SQL
3 votes141 views2 answers
Postgres download
SQL
0 vote546 views1 answer
How to connect .sql data set to powerbi
SQL
0 vote198 views1 answer
Postgresql alter table sequence
SQL
0 vote156 views1 answer
Update and keep original value sql
SQL
15 votes158 views2 answers
Open postgress in terminal mac
SQL
0 vote180 views1 answer
Sql create and grant user access to database
SQL
2 votes183 views1 answer
Sqlite3 show columns name
SQL
0 vote158 views1 answer
Heidisql check how much space a row
SQL