is used to remove an existing NOTIFY registration.
UNLISTEN cancels any existing registration of the current
PostgreSQL session as a listener on the notify
The special condition wildcard * cancels all listener registrations
for the current session.
contains a more extensive
discussion of the use of LISTEN and
need not be a valid class name but can be any string valid
as a name up to 64 characters long.
The backend does not complain if you unlisten something you were not
Each backend will automatically execute UNLISTEN * when
To subscribe to an existing registration:
Asynchronous NOTIFY 'virtual' from backend with pid '8448' received
Once UNLISTEN has been executed, further NOTIFY commands will be
-- notice no NOTIFY event is received