Re: Verifying LISTEN subscriptions?

From: Deven Phillips <deven(dot)phillips(at)gmail(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Verifying LISTEN subscriptions?
Date: 2016-09-17 12:51:56
Message-ID: CAJw+4NAhOivupLU6_wwXB81MSFJBXmv1iN3y0MXmURf39v6YvA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

NVM, a quick search through the output of `\dfS` showed me the
`pg_listening_channels()` function, which returns a TEXT[] of currently
subscribed channels.

Cheers,

Deven

On Sat, Sep 17, 2016 at 8:45 AM, Deven Phillips <deven(dot)phillips(at)gmail(dot)com>
wrote:

> From a connection which has previously executed a LISTEN <channel>
> statement, is there a query which I can run which will tell me if it is
> still listening on those channels?
>
> Thanks in advance!!
>
> Deven Phillips
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Nikolai Zhubr 2016-09-17 13:14:37 Re: Nonblocking libpq + openssl = ?
Previous Message Deven Phillips 2016-09-17 12:45:15 Verifying LISTEN subscriptions?