Re: Catalog for LISTEN'ed to notification channels?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Dominique Devienne <ddevienne(at)gmail(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Catalog for LISTEN'ed to notification channels?
Date: 2023-06-22 13:29:59
Message-ID: 4047830.1687440599@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Dominique Devienne <ddevienne(at)gmail(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Abhishek Dasgupta 2023-06-22 13:46:21 FIPS-related Error: Password Must Be at Least 112 Bits on Postgres 14, Unlike in Postgres 11
Previous Message Amit Kapila 2023-06-22 10:52:30 Re: Support logical replication of DDLs