| From: | Sakshi Jain <sakshijain10388(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Fwd: Listen and notify in psql process |
| Date: | 2021-06-17 11:04:27 |
| Message-ID: | CACjnedKwj7KwgFLfaYmTh4=HKR6ZE6uvkgn-D9RSbHpMznt-oA@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-sql |
Hi Team,
How to listen from within a psql process and get the payloads?
Do Postgresql 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.
I am looking for listen to return some thing when a notify has been issued.
--
*Thanks & Regards*
Sakshi Jain
New Delhi
8882433263
--
*Thanks & Regards*
Sakshi Jain
New Delhi
8882433263
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ravi Krishna | 2021-06-17 11:45:27 | Re: Listen and notify in psql process |
| Previous Message | Sakshi Jain | 2021-06-17 11:01:41 | Listen and notify in psql process |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ravi Krishna | 2021-06-17 11:45:27 | Re: Listen and notify in psql process |
| Previous Message | Sakshi Jain | 2021-06-17 11:01:41 | Listen and notify in psql process |