Is it possible to write a generic trigger for all tables in Postgres?

Question

I want to listen to every transaction that is recorded in the database And I noticed that there is a concept in Postgres under the title LISTEN and NOTIFY (Of course, I am not sure that this is the right way)

Now I want to write a trigger that sends a notification to the channel when any operation occurs in any table

Is it possible?

My way is right?

thanks

Postgres TRIGGER to call NOTIFY with a JSON payload

Answer 1

You can try to create an event trigger on ddl_command_end, then inside that event trigger create a regular trigger when a "CREATE TABLE" statement is executed, so you can automatically keep track of all newly created tables.