Search code examples
postgresqllistener

in postgres, can one query the current listeners?


in the notify / listen for postgres, one listens through

listen channel

is there a way to query the current channels to which the session is listening?

have gone through doc with luck as yet.


Solution

  • select * 
    from pg_listening_channels() 
    

    This is listed in the chapter "System Information Functions":

    http://www.postgresql.org/docs/current/static/functions-info.html