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.

user330315 · Accepted Answer · 2022-08-03 09:25:06Z

7

These are available in system table pg_event_trigger

answered Aug 3, 2022 at 9:25

user330315

Sign up to request clarification or add additional context in comments.

Comments

Super Kai - Kazuya Ito · Accepted Answer · 2024-01-15 10:09:57Z

0

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;

answered Jan 15, 2024 at 10:09

Super Kai - Kazuya Ito

42.8k23 gold badges258 silver badges257 bronze badges

Collectives™ on Stack Overflow

Show all event triggers in a database in PostgreSQL

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related