# UNLISTEN(7) - man - phpMan

[UNLISTEN(7)](https://www.chedong.com/phpMan.php/man/UNLISTEN/7/markdown)                        PostgreSQL 14.23 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 14.23                                2026                                     [UNLISTEN(7)](https://www.chedong.com/phpMan.php/man/UNLISTEN/7/markdown)