Show all event triggers in a database in PostgreSQL

Question

If we query pg_trigger then we don't get the event triggers, we get list of only normal triggers.

So, is there any other specific table where we can check the event triggers.

Answer 1

This can show all user-defined event triggers in the current database:

\dy

And, this can show all user-defined event triggers in the current database in detail:

\dy+

And, you can show all user-defined event triggers in the current database with pg_event_trigger as shown below. *There is no way to show all event triggers in all databases at once:

SELECT * FROM pg_event_trigger;

Answer 2

These are available in system table pg_event_trigger