How to view existing event triggers (Event Trigger, postgresql)?

Question

PostgreSQL

I can't find the answer in the postgresql docs. How to create / delete / enable / disable - found, but how to view the created ones - no? Can you see them at all?

Answer 1

They are registered in the system view pg_event_trigger
https://www.postgresql.org/docs/9.6/static/catalog...
In psql there is a shortcut \dy that executes the following query:

SELECT evtname as "Name", evtevent as "Event", pg_catalog.pg_get_userbyid(e.evtowner) as "Owner",
 case evtenabled when 'O' then 'enabled'  when 'R' then 'replica'  when 'A' then 'always'  when 'D' then 'disabled' end as "Enabled",
 e.evtfoid::pg_catalog.regproc as "Procedure", pg_catalog.array_to_string(array(select x from pg_catalog.unnest(evttags) as t(x)), ', ') as "Tags"
FROM pg_catalog.pg_event_trigger e ORDER BY 1