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 ".
>
https://www.postgresql.org/docs/current/sql-notify.html
https://www.postgresql.org/docs/13/sql-listen.html
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