2
.\" Title: dblink_get_notify
3
.\" Author: The PostgreSQL Global Development Group
4
.\" Generator: DocBook XSL Stylesheets v1.75.1 <http://docbook.sf.net/>
6
.\" Manual: PostgreSQL 9.1beta1 Documentation
7
.\" Source: PostgreSQL 9.1beta1
10
.TH "DBLINK_GET_NOTIFY" "3" "2011-04-27" "PostgreSQL 9.1beta1" "PostgreSQL 9.1beta1 Documentation"
11
.\" -----------------------------------------------------------------
12
.\" * set default formatting
13
.\" -----------------------------------------------------------------
14
.\" disable hyphenation
16
.\" disable justification (adjust text to left margin only)
18
.\" -----------------------------------------------------------------
19
.\" * MAIN CONTENT STARTS HERE *
20
.\" -----------------------------------------------------------------
22
dblink_get_notify \- retrieve async notifications on a connection
26
dblink_get_notify() returns setof (notify_name text, be_pid int, extra text)
27
dblink_get_notify(text connname) returns setof (notify_name text, be_pid int, extra text)
31
\fBdblink_get_notify\fR
32
retrieves notifications on either the unnamed connection, or on a named connection if specified\&. To receive notifications via dblink,
34
must first be issued, using
35
\fBdblink_exec\fR\&. For details see
43
The name of a named connection to get notifications on\&.
48
setof (notify_name text, be_pid int, extra text), or an empty set if none\&.
55
SELECT dblink_exec(\(aqLISTEN virtual\(aq);
57
\-\-\-\-\-\-\-\-\-\-\-\-\-
61
SELECT * FROM dblink_get_notify();
62
notify_name | be_pid | extra
63
\-\-\-\-\-\-\-\-\-\-\-\-\-+\-\-\-\-\-\-\-\-+\-\-\-\-\-\-\-
69
SELECT * FROM dblink_get_notify();
70
notify_name | be_pid | extra
71
\-\-\-\-\-\-\-\-\-\-\-\-\-+\-\-\-\-\-\-\-\-+\-\-\-\-\-\-\-