Postgres list all triggers

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;

Similar codes

0 vote201 views1 answer
Org.apache.spark.sql.avro.IncompatibleSchemaException: Unexpected type org.apache.spark.ml.linalg.VectorUDT
SQL
-1 vote211 views2 answers
Sql query examples
SQL
5 votes185 views1 answer
Sql first day of current year
SQL
1 vote292 views1 answer
Oracle select first row order by
SQL
24 votes220 views6 answers
Sql change table name
SQL
1 vote214 views1 answer
Sql select row with max date
SQL
0 vote195 views1 answer
How to start my sql server on mac
SQL
8 votes224 views1 answer
Oracle alter tablespace add datafile autoextend max size
SQL
0 vote197 views1 answer
Sql server manager close connection
SQL
0 vote222 views1 answer
Connect postgresql using a connection string
SQL