Postgres Pro
Downloads
Home   >   mailing lists

Listen and notify in psql process - Mailing list pgsql-sql

From Sakshi Jain
Subject Listen and notify in psql process
Date
Msg-id CACjnedJREryjgkHBtpuDY+xo2MtVVrnt6KFyCvh4TAgxnNaKMg@mail.gmail.com
Whole thread Raw
Responses Re: Listen and notify in psql process
List pgsql-sql
Tree view
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
 

pgsql-sql by date:

Previous
From: Дмитрий Иванов
Date:
Subject: Re: function INPUT as whole table
Next
From: Erik Brandsberg
Date:
Subject: Re: Listen and notify in psql process