Description
array
pg_get_notify ( resource
connection [, int result_type])
pg_get_notify() gets notify
message sent by NOTIFY SQL command.
To recieve nofigy messages, LISTEN
SQL command must be issued. If there is notify message on the
connection, array contains message name and backend PID is
returned. If there is no message,
FALSE is returned.
See also pg_get_pid()
範例 1. PostgreSQL NOTIFY message
?php
$conn = pg_pconnect ("dbname=publisher");
if (!$conn) {
echo "An error occured.\n";
exit;
}
// Listen 'author_updated' message from other processes
pq_query($conn, 'LISTEN author_updated;');
$notify = pg_get_notify($conn);
if (!$notify)
print("No messages\n");
else
print_r($notify);
?
|
|