Re: Listen and notify in psql process

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
[image: AWS Competency Program]
<https://aws.amazon.com/partners/find/partnerdetails/?n=Heimdall%20Data&id=001E000001d9pndIAA>