PHP 5.4.31 Released

pg_get_notify

(PHP 4 >= 4.3.0, PHP 5)

pg_get_notifyPing database connection

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()

Example #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);
?>

add a note add a note

User Contributed Notes

There are no user contributed notes for this page.
To Top