| From: | Erik Brandsberg <erik(at)heimdalldata(dot)com> |
|---|---|
| To: | Sakshi Jain <sakshijain10388(at)gmail(dot)com> |
| Cc: | pgsql-sql(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Listen and notify in psql process |
| Date: | 2021-06-17 14:22:34 |
| Message-ID: | CAFcck8G5kZxg=ctuXuO50jAxK4H_FXbUOsAzWdibLfw3bGMuSg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-sql |
Google for Postgres listen notify... ;) It is in the documentation.
On Thu, Jun 17, 2021 at 7:02 AM Sakshi Jain <sakshijain10388(at)gmail(dot)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(at)heimdalldata(dot)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>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Vijaykumar Jain | 2021-06-17 14:39:54 | compute_query_id |
| Previous Message | Celia McInnis | 2021-06-17 14:13:05 | Treating float arrays as vectors? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | JORGE MALDONADO | 2021-06-21 19:07:17 | Help to design relations between some 5 tables with possible many-to-many relations |
| Previous Message | Torsten Förtsch | 2021-06-17 13:34:05 | Re: Listen and notify in psql process |