Is it possible to write a generic trigger for all tables in Postgres?
0
votes
1
answer
480
views
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
Asked by mostafa hosseini
(101 rep)
Dec 20, 2022, 03:33 PM
Last activity: Jun 4, 2025, 04:03 AM
Last activity: Jun 4, 2025, 04:03 AM