GSP
Quick Navigator

Search Site

Unix VPS
A - Starter
B - Basic
C - Preferred
D - Commercial
MPS - Dedicated
Previous VPSs
* Sign Up! *

Support
Contact Us
Online Help
Handbooks
Domain Status
Man Pages

FAQ
Virtual Servers
Pricing
Billing
Technical

Network
Facilities
Connectivity
Topology Map

Miscellaneous
Server Agreement
Year 2038
Credits
 

USA Flag

 

 

Man Pages
DBLINK_SEND_QUERY(3) PostgreSQL 14.2 Documentation DBLINK_SEND_QUERY(3)

dblink_send_query - sends an async query to a remote database

dblink_send_query(text connname, text sql) returns int

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.

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.

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

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

Search for    or go to Top of page |  Section 3 |  Main Index

Powered by GSP Visit the GSP FreeBSD Man Page Interface.
Output converted with ManDoc.