Verifying LISTEN subscriptions?
Started by Deven Phillipsover 9 years ago2 messagesgeneral
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
Re: Verifying LISTEN subscriptions?
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.phillips@gmail.com>
wrote:
Show quoted text
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