Cory Tucker <cory.tucker@xxxxxxxxx> writes: > I'm interested in trying to figure out which channels have been subscribed > to (using LISTEN). From what I could tell via a little Googling, there > used to be a table named pg_catalog.pg_listener that contained all this > information, but that seems to have disappeared somewhere in the 9.x > release (I'm using 9.3.x). > Is there a way to find out which channels have listeners? No, not any more --- that capability was intentionally given up in the 9.0 LISTEN/NOTIFY rewrite. Not that it wouldn't be nice to have, but the cost/benefit ratio was pretty awful. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
