dblink_get_notify man page on Oracle

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

DBLINK_GET_NOTIFY(3)	PostgreSQL 9.2.7 Documentation	  DBLINK_GET_NOTIFY(3)

NAME
       dblink_get_notify - retrieve async notifications on a connection

SYNOPSIS
       dblink_get_notify() returns setof (notify_name text, be_pid int, extra text)
       dblink_get_notify(text connname) returns setof (notify_name text, be_pid int, extra text)

DESCRIPTION
       dblink_get_notify retrieves notifications on either the unnamed
       connection, or on a named connection if specified. To receive
       notifications via dblink, LISTEN must first be issued, using
       dblink_exec. For details see LISTEN(7) and NOTIFY(7).

ARGUMENTS
       conname
	   The name of a named connection to get notifications on.

RETURN VALUE
       Returns setof (notify_name text, be_pid int, extra text), or an empty
       set if none.

EXAMPLES
	   SELECT dblink_exec('LISTEN virtual');
	    dblink_exec
	   -------------
	    LISTEN
	   (1 row)

	   SELECT * FROM dblink_get_notify();
	    notify_name | be_pid | extra
	   -------------+--------+-------
	   (0 rows)

	   NOTIFY virtual;
	   NOTIFY

	   SELECT * FROM dblink_get_notify();
	    notify_name | be_pid | extra
	   -------------+--------+-------
	    virtual	|   1229 |
	   (1 row)

PostgreSQL 9.2.7		  2014-02-17		  DBLINK_GET_NOTIFY(3)
[top]

List of man pages available for Oracle

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