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 vote206 views1 answer
How many columns can be used for creating index?
SQL
6 votes230 views3 answers
Error Code: 1055. Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'mydb.term.year' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
0 vote235 views1 answer
Group by 15 minute interval sql server
SQL
-1 vote220 views2 answers
Postgresql get last 10 records
SQL
1 vote212 views4 answers
Psql check tables command
SQL
0 vote209 views1 answer
Não é possível executar uma operação DML dentro de uma consulta
SQL
10 votes219 views1 answer
User_dependencies
SQL
5 votes206 views3 answers
Truncate function in sql oracle
SQL
1 vote223 views1 answer
Importance of comment in mysql
SQL
2 votes223 views1 answer
Sql skip the first row
SQL