stop listening for a notification NAME UNLISTEN - stop listening for a notification SYNOPSIS UNLISTEN { channel | * } DESCRIPTION UNLISTE......ient application. A session can be unregistered for a given notification channel with the UNLISTEN command. A session's listen registrations are automatically cleared when the s…...e of statements: CLOSE ALL; SET SESSION AUTHORIZATION DEFAULT; RESET ALL; DEALLOCATE ALL; UNLISTEN *; SELECT pg_advisory_unlock_all(); DISCARD PLANS; DISCARD TEMP; DISCARD SEQUE…...or the session's temporary namespace, created any cursors WITH HOLD, or executed LISTEN , UNLISTEN , or NOTIFY . Those features are too tightly tied to the current session to be…...728. COMPATIBILITY There is no NOTIFY statement in the SQL standard. SEE ALSO LISTEN (7), UNLISTEN (7), max_notify_queue_pages