DBLINK_SEND_QUERY

Section: PostgreSQL 15.6 Documentation (3)
Updated: 2024
Index Return to Main Contents
 

NAME

dblink_send_query - sends an async query to a remote database  

SYNOPSIS

dblink_send_query(text connname, text sql) returns int
 

DESCRIPTION

dblink_send_query sends a query to be executed asynchronously, that is, without immediately waiting for the result. There must not be an async query already in progress on the connection.

After successfully dispatching an async query, completion status can be checked with dblink_is_busy, and the results are ultimately collected with dblink_get_result. It is also possible to attempt to cancel an active async query using dblink_cancel_query.  

ARGUMENTS

connname

Name of the connection to use.

sql

The SQL statement that you wish to execute in the remote database, for example select * from pg_class.
 

RETURN VALUE

Returns 1 if the query was successfully dispatched, 0 otherwise.  

EXAMPLES

SELECT dblink_send_query('dtest1', 'SELECT * FROM foo WHERE f1 < 3');


 

Index

NAME
SYNOPSIS
DESCRIPTION
ARGUMENTS
RETURN VALUE
EXAMPLES

This document was created by man2html, using the manual pages.
Time: 02:14:59 GMT, April 25, 2024