PG_GET_NOTIFY(3) PG_GET_NOTIFY(3)
pg_get_notify - Gets SQL NOTIFY message
SYNOPSIS
array pg_get_notify (resource $connection, [int $result_type])
DESCRIPTION
pg_get_notify(3) gets notifications generated by a NOTIFY SQL command. To receive notifications, the LISTEN SQL command must be issued.
PARAMETERS
o $connection
- PostgreSQL database connection resource.
o $result_type
- An optional parameter that controls how the returned array is indexed. $result_type is a constant and can take the following
values: PGSQL_ASSOC, PGSQL_NUM and PGSQL_BOTH. Using PGSQL_NUM, pg_get_notify(3) will return an array with numerical indices,
using PGSQL_ASSOC it will return only associative indices while PGSQL_BOTH, the default, will return both numerical and associa-
tive indices.
RETURN VALUES
An array containing the NOTIFY message name and backend PID. Otherwise if no NOTIFY is waiting, then FALSE is returned.
EXAMPLES
Example #1
PostgreSQL NOTIFY message
<?php
$conn = pg_pconnect("dbname=publisher");
if (!$conn) {
echo "An error occurred.
";
exit;
}
// Listen 'author_updated' message from other processes
pg_query($conn, 'LISTEN author_updated;');
$notify = pg_get_notify($conn);
if (!$notify) {
echo "No messages
";
} else {
print_r($notify);
}
?>
SEE ALSO
pg_get_pid(3).
PHP Documentation Group PG_GET_NOTIFY(3)