Name

Synopsis

UNLISTEN {channel | * }

Description

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

NOTIFY contains a more extensive discussion of the use ofLISTEN andNOTIFY.

Parameters

Notes

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

At the end of each session,UNLISTEN * is automatically executed.

A transaction that has executedUNLISTEN cannot be prepared for two-phase commit.

Examples

To make a registration:

LISTEN virtual;NOTIFY virtual;Asynchronous notification "virtual" received from server process with PID 8448.

OnceUNLISTEN has been executed, furtherNOTIFY messages will be ignored:

UNLISTEN virtual;NOTIFY virtual;-- no NOTIFY event is received

Compatibility

There is noUNLISTEN command in the SQL standard.

See Also