LISTEN & NOTIFY

listen and notify can be used when you want to subscribe to changes in a table, this is how it can be used

• used to subscribe to INSERT changes in a db eg for CRM subscribe to the deployment table and update all the instances at once
• used to subscribe to a table that has all the information for something to be processed, then we can subscribe to the INSERT & UPDATE changes in the db and process the query as needed example event handler.

more about listen & notify a post that goes in detail