pg_get_notify

Description

pg_get_notify() gets notifications generated by a NOTIFY SQL command. To receive notifications, the LISTEN SQL command must be issued.

Parameters

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 occured.\n";   exit; } // Listen 'author_updated' message from other processes pg_query($conn, 'LISTEN author_updated;'); $notify = pg_get_notify($conn); if (!$notify) {   echo "No messages\n"; } else {   print_r($notify); } ?>

See Also