pg_get_notify

Ping database connection (PHP 4 >= 4.3.0)
array pg_get_notify ( resource connection [, int result_type] )

pg_get_notify() gets notify message sent by NOTIFY SQL command. To recieve notify 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()

Example 758. PostgreSQL NOTIFY message

copy to clipboard
<?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);
?>

This HTML Help has been published using the chm2web software.