Postgres Pro
Downloads
Home   >   mailing lists

Re: Listen and notify in psql process - Mailing list pgsql-sql

From Erik Brandsberg
Subject Re: Listen and notify in psql process
Date
Msg-id CAFcck8G5kZxg=ctuXuO50jAxK4H_FXbUOsAzWdibLfw3bGMuSg@mail.gmail.com
Whole thread Raw
In response to Listen and notify in psql process  (Sakshi Jain <sakshijain10388@gmail.com>)
List pgsql-sql
Tree view
Google for Postgres listen notify... ;)  It is in the documentation.

On Thu, Jun 17, 2021 at 7:02 AM Sakshi Jain <sakshijain10388@gmail.com> wrote:
Hi Team,

How to listen from within a psql process and get the payloads?

Do Postgres have any such a mechanism where in a session a process send a "listen <name>" sql command and then gets a message if someone in the other session issued a "notify <name>".

Please provide an example of how to do this.

--
Thanks & Regards
Sakshi Jain
New Delhi
8882433263
 


--
Erik Brandsberg
erik@heimdalldata.com

www.heimdalldata.com
+1 (866) 433-2824 x 700
AWS Competency Program

pgsql-sql by date:

Previous
From: Sakshi Jain
Date:
Subject: Listen and notify in psql process
Next
From: JORGE MALDONADO
Date:
Subject: Help to design relations between some 5 tables with possible many-to-many relations