Postgres Pro
Downloads
Home   >   mailing lists

Re: Catalog for LISTEN'ed to notification channels? - Mailing list pgsql-general

From Tom Lane
Subject Re: Catalog for LISTEN'ed to notification channels?
Date
Msg-id 4047830.1687440599@sss.pgh.pa.us
Whole thread Raw
In response to Catalog for LISTEN'ed to notification channels?  (Dominique Devienne <ddevienne@gmail.com>)
Responses Re: Catalog for LISTEN'ed to notification channels?  (Dominique Devienne <ddevienne@gmail.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: "xxai.art"
Date:
Subject: postgresql 16beta1-alpine3.18 : build plugin , VARSIZE_ANY_EXHDR: symbol not found
Next
From: Abhishek Dasgupta
Date:
Subject: FIPS-related Error: Password Must Be at Least 112 Bits on Postgres 14, Unlike in Postgres 11