Re: Listen and notify in psql process

2021-06-17 Thread Torsten Förtsch
On Thu, Jun 17, 2021 at 1:04 PM Sakshi Jain wrote: 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 " sql command and then gets a message if someone in the > other session issued a "notify ". >

Re: Listen and notify in psql process

2021-06-17 Thread Ravi Krishna
https://www.postgresql.org/docs/current/sql-notify.html https://www.postgresql.org/docs/13/sql-listen.html

Fwd: Listen and notify in psql process

2021-06-17 Thread Sakshi Jain
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 " sql command and then gets a message if someone in the other session issued a "notify ". Please provide an example of how to do this. I am