UNLISTEN

Name

UNLISTEN -- stop listening for a
notification

Synopsis

UNLISTEN { name | * }

Description

UNLISTEN is used to remove an
existing registration for NOTIFY events.
UNLISTEN cancels any existing
registration of the current PostgreSQL session as a listener on the
notification name. The special
wildcard * cancels all listener
registrations for the current session.

NOTIFY contains a
more extensive discussion of the use of LISTEN and NOTIFY.

Parameters

name

Name of a notification (any identifier).

*

All current listen registrations for this session are
cleared.

Notes

You can unlisten something you were not listening for; no
warning or error will appear.