Sample Header Ad - 728x90

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