Index for Section 5

Alphabetical listing for U

Bottom of page

UNLISTEN(5)
NAME
  UNLISTEN - stop listening for a notification

SYNOPSIS
  UNLISTEN { notifyname | * }

  INPUTS

  notifyname
       Name of previously registered notify condition.

  *    All current listen registrations for this backend are cleared.

  OUTPUTS

  UNLISTEN
       Acknowledgment that statement has executed.

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

  NOTIFY [notify(5)] contains a more extensive discussion of the use of
  LISTEN and NOTIFY.

  NOTES

  notifyname need not be a valid class name but can be any string valid as a
  name up to 32 characters long.

  The backend does not complain if you UNLISTEN something you were not
  listening for.  Each backend will automatically execute UNLISTEN * when
  exiting.

USAGE
  To subscribe to an existing registration:

  LISTEN virtual;
  LISTEN
  NOTIFY virtual;
  NOTIFY
  Asynchronous NOTIFY 'virtual' from backend with pid '8448' received

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

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

COMPATIBILITY
  SQL92

  There is no UNLISTEN in SQL92.

Index for Section 5

Alphabetical listing for U

Top of page