Unix/Linux Go Back    


CentOS 7.0 - man page for dblink_send_query (centos section 3)

Linux & Unix Commands - Search Man Pages
Man Page or Keyword Search:   man
Select Man Page Set:       apropos Keyword Search (sections above)


DBLINK_SEND_QUERY(3)		  PostgreSQL 9.2.7 Documentation	     DBLINK_SEND_QUERY(3)

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
       conname
	   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');

PostgreSQL 9.2.7			    2014-02-17			     DBLINK_SEND_QUERY(3)
Unix & Linux Commands & Man Pages : 2000 - 2018 Unix and Linux Forums


All times are GMT -4. The time now is 09:41 AM.