Re: Listen and notify in psql process

Поиск
Список
Период
Сортировка
От Erik Brandsberg
Тема Re: Listen and notify in psql process
Дата
Msg-id CAFcck8G5kZxg=ctuXuO50jAxK4H_FXbUOsAzWdibLfw3bGMuSg@mail.gmail.com
обсуждение исходный текст
Ответ на Listen and notify in psql process  (Sakshi Jain <sakshijain10388@gmail.com>)
Список pgsql-sql
Дерево обсуждения
Google for Postgres listen notify... ;)  It is in the documentation.

On Thu, Jun 17, 2021 at 7:02 AM Sakshi Jain <sakshijain10388@gmail.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@heimdalldata.com

www.heimdalldata.com
+1 (866) 433-2824 x 700
AWS Competency Program

В списке pgsql-sql по дате отправления:

Предыдущее
От: Sakshi Jain
Дата:
Сообщение: Listen and notify in psql process
Следующее
От: JORGE MALDONADO
Дата:
Сообщение: Help to design relations between some 5 tables with possible many-to-many relations