Is it possible to listen to all notification that are broadcast by Postgress? For example something like LISTEN * without having to create any ad-hoc channels like all_channels? I need this to minimize the number of active connection that are listening to notifications. Imagine that there would be 200 channels, this approach can actually minimize the number of active connections to only 1 for capturing all notifications.
>Solution :
No, that is not possible. Try to come up with a design that needs fewer channels – perhaps you can differentiate via the payload of the notification:
NOTIFY channel, '4711';