# UNLISTEN - stop listening for a notification - man(7) - [phpMan]

[_UNLISTEN_(7)](https://www.chedong.com/phpMan.php/man/UNLISTEN/7/markdown)                        PostgreSQL 16.14 Documentation                        [_UNLISTEN_(7)](https://www.chedong.com/phpMan.php/man/UNLISTEN/7/markdown)

## NAME
       UNLISTEN - stop listening for a notification

## SYNOPSIS
       UNLISTEN { _channel_ | * }

## 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
       channel named _channel_. The special wildcard * cancels all listener registrations for the
       current session.

       [**NOTIFY**(7)](https://www.chedong.com/phpMan.php/man/NOTIFY/7/markdown) contains a more extensive discussion of the use of **LISTEN **and **NOTIFY**.

## PARAMETERS
       _channel_
           Name of a notification channel (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.

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

       A transaction that has executed **UNLISTEN **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.

       Once **UNLISTEN **has been executed, further **NOTIFY **messages will be ignored:

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

## COMPATIBILITY
       There is no **UNLISTEN **command in the SQL standard.

## SEE ALSO
       [**LISTEN**(7)](https://www.chedong.com/phpMan.php/man/LISTEN/7/markdown), [**NOTIFY**(7)](https://www.chedong.com/phpMan.php/man/NOTIFY/7/markdown)

PostgreSQL 16.14                                2026                                     [_UNLISTEN_(7)](https://www.chedong.com/phpMan.php/man/UNLISTEN/7/markdown)