pg_listening_channels() - Mailing list pgsql-general

From Igor Neyman
Subject pg_listening_channels()
Date
Msg-id A76B25F2823E954C9E45E32FA49D70EC08EF46E4@mail.corp.perceptron.com
Whole thread Raw
Responses Re: pg_listening_channels()  ("Greg Sabino Mullane" <greg@turnstep.com>)
List pgsql-general

Hello,

 

In Postgresql 9.2 this function pg_listening_channels() returns the channels that the current session/connection listens to.

 

How (if it’s even possible) can I get listening channels for all sessions/ connections in the database?

With older versions I could just query “pg_listener WHERE relname = listener_name”.  Not any more, the table doesn’t exist in newer versions.

 

Regards,

Igor Neyman

pgsql-general by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: Correlation in pg_stats
Next
From: Rodrigo Rosenfeld Rosas
Date:
Subject: distinct values and count over window function