DBLINK_GET_NOTIFY(3) PostgreSQL 9.2.7 Documentation DBLINK_GET_NOTIFY(3)NAME
dblink_get_notify - retrieve async notifications on a connection
SYNOPSIS
dblink_get_notify() returns setof (notify_name text, be_pid int, extra text)
dblink_get_notify(text connname) returns setof (notify_name text, be_pid int, extra text)
DESCRIPTION
dblink_get_notify retrieves notifications on either the unnamed connection, or on a named connection if specified. To receive notifications
via dblink, LISTEN must first be issued, using dblink_exec. For details see LISTEN(7) and NOTIFY(7).
ARGUMENTS
conname
The name of a named connection to get notifications on.
RETURN VALUE
Returns setof (notify_name text, be_pid int, extra text), or an empty set if none.
EXAMPLES
SELECT dblink_exec('LISTEN virtual');
dblink_exec
-------------
LISTEN
(1 row)
SELECT * FROM dblink_get_notify();
notify_name | be_pid | extra
-------------+--------+-------
(0 rows)
NOTIFY virtual;
NOTIFY
SELECT * FROM dblink_get_notify();
notify_name | be_pid | extra
-------------+--------+-------
virtual | 1229 |
(1 row)
PostgreSQL 9.2.7 2014-02-17 DBLINK_GET_NOTIFY(3)
Check Out this Related Man Page
PG_GET_NOTIFY(3)PG_GET_NOTIFY(3)pg_get_notify - Gets SQL NOTIFY messageSYNOPSIS
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)
I am comparing text files where there are number of rows of numbers from window to unix box
Is there any way of checking lets say 4 document of text file
and seeing the difference only (or missing rows of numbers)
with simple commands with lets say a batch file
FROM ABSOULTE... (2 Replies)
Hi,
I am using the NOTIFY command and I am getting the emails.. I tried MAILX and e-mail is being sent. I want to use NOTIFY to see if my jobs are completed or not. Am I missing something..
All your ideas are greatly appreciated..
Thanks
Venky (2 Replies)
how to insert a extra line in a text file using a sh command
iam trying to think of a way to add a extra line but without deleting the whole text
do anyone have any ideas (2 Replies)
Hi,
I wanted to add specific text to each row in a text file containing three rows. Example:
0 8 7 6 5 5
7 8 9 0 7 9
7 8 9 0 1 2
And I want to add a 21 at the beginning of the first row, and blank spaces at the beginning of the second two rows. To get this:
21 0 8 7 6 5 5
7 8... (4 Replies)
I am new to scripting and I needed to know if there would be an easy way to delete extra spaces in a text file. I have a file with three rows with 22 numbers each, but there is extra spaces between the numbers when it gets output by this program AFNI that I am using. What script would help delete... (2 Replies)
I have a requirement where i have to read from a .sh file a text lying bet characters like 'SELECT' & ';'...Please help me out in this. I am new to shell scripting. (2 Replies)
Hi all,
I have a requirement where i have to search data between strings 'SELECT' and ';' and replace this text as "SELECT.....;" so that i can export this extracted string into a excel cell.
Please suggest on this. (5 Replies)
just a quick question:
a. whats the simplest command to check open port and the corresponding services?
example:
bash-2.05# netstat -an | grep LISTEN
*.199 *.* 0 0 49152 0 LISTEN
*.8989 *.* 0 0 49152 ... (1 Reply)
Input:
some random text SELECT TABLE1 some more random text
some random text SELECT TABLE2 some more random text
some random text SELECT TABLE3 some more random text
some random text SELECT TABLE1 some more random text
Output:
'SELECT TABLE1' 2
'SELECT TABLE2' 1
'SELECT TABLE3' 1
I... (5 Replies)
Hello,
I am currently monitoring about 40 hosts using NsClient. Each host has between 5-8 services running on each of them. I was trying to find a way to get less notifications because I'm currently getting about 200 a week. Is there anyway for if one service goes down on a host to make nagios... (5 Replies)
I need to sum values in text file in case duplicate row are present with same name and different value below is example of data in file i have and format i need.
Data in text file
20170308
PM,U,2
PM,U,1
PM,U, 113
PM,I,123
PM,U,123
DA,U 135
DA,I,113
DA,I,1
DA,U,22
20170309
PM,U,2... (6 Replies)