Skip site navigation (1)Skip section navigation (2)

FreeBSD Manual Pages

  
 
  

home | help
DBLINK_GET_NOTIFY(3)	PostgreSQL 9.6.3 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
       connname
	   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.6.3		     2017		  DBLINK_GET_NOTIFY(3)

NAME | SYNOPSIS | DESCRIPTION | ARGUMENTS | RETURN VALUE | EXAMPLES

Want to link to this manual page? Use this URL:
<https://www.freebsd.org/cgi/man.cgi?query=dblink_get_notify&sektion=3&manpath=FreeBSD+12.1-RELEASE+and+Ports>

home | help