Re: Catalog for LISTEN'ed to notification channels?

Dominique Devienne <ddevienne@gmail.com> writes:
> Can I introspect which "channel(s)" the current (or any other session) is
> LISTEN'ing to?

The pg_listening_channels() function will show you channel names the
current session is listening to.  There's no way to find out about
other sessions, because that state is only backend-local.

            regards, tom lane