centos man page for dblink_get_notify

Query: dblink_get_notify

OS: centos

Section: 3

Format: Original Unix Latex Style Formatted with HTML and a Horizontal Scroll Bar

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)
Related Man Pages
dblink(3) - centos
dblink_exec(3) - centos
dblink_get_result(3) - centos
dblink_open(3) - centos
listen(7) - suse
Similar Topics in the Unix Linux Community
Talend Open Profiler 1.1.0 (Default branch)
Talend Open Profiler 1.2.0M1 (Development branch)
csh script for deleting extra spaces in text file
search and replace a text in a file
open ports and services