Re: [GENERAL] Verifying LISTEN subscriptions?

2016-09-17 Thread Deven Phillips
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 wrote: > From a connection which has previously executed a LISTEN > statem

[GENERAL] Verifying LISTEN subscriptions?

2016-09-17 Thread Deven Phillips
>From a connection which has previously executed a LISTEN 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