unlisten man page on aLinux

Man page or keyword search:  
man Server   7435 pages
apropos Keyword Search (all sections)
Output format
aLinux logo
[printable version]

UNLISTEN()			 SQL Commands			    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 [notify(7)] 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  may	 unlisten  something you were not listening for; no warning or
       error will appear.

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

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  commands  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 [listen(7)], NOTIFY [notify(l)]

SQL - Language Statements	  2005-11-05			    UNLISTEN()
[top]

List of man pages available for aLinux

Copyright (c) for man pages and the logo by the respective OS vendor.

For those who want to learn more, the polarhome community provides shell access and support.

[legal] [privacy] [GNU] [policy] [cookies] [netiquette] [sponsors] [FAQ]
Tweet
Polarhome, production since 1999.
Member of Polarhome portal.
Based on Fawad Halim's script.
....................................................................
Vote for polarhome
Free Shell Accounts :: the biggest list on the net