NAME dblink_is_busy – checks if connection is busy with an async query SYNOPSIS dblink_is_busy(text connname) returns int DESCRIPTION dblink_is_busy tests whether an async query is in progress. ARGUMENTS connname Name of the connection to check. RETURN VALUE Returns 1 if connection is busy, 0 if it is not busy. If this function returns 0, it…
NAME dblink_get_result – gets an async query result SYNOPSIS dblink_get_result(text connname [, bool fail_on_error]) returns setof record DESCRIPTION dblink_get_result collects the results of an asynchronous query previously sent with dblink_send_query. If the query is not already completed, dblink_get_result will wait until it is. ARGUMENTS connname Name of the connection to use. fail_on_error If true (the…
NAME dblink_get_pkey – returns the positions and field names of a relation’s primary key fields SYNOPSIS dblink_get_pkey(text relname) returns setof dblink_pkey_results DESCRIPTION dblink_get_pkey provides information about the primary key of a relation in the local database. This is sometimes useful in generating queries to be sent to remote databases. ARGUMENTS relname Name of a local…
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,…
NAME dblink_get_connections – returns the names of all open named dblink connections SYNOPSIS dblink_get_connections() returns text[] DESCRIPTION dblink_get_connections returns an array of the names of all open named dblink connections. RETURN VALUE Returns a text array of connection names, or NULL if none. EXAMPLES SELECT dblink_get_connections(); Index
NAME dblink_fetch – returns rows from an open cursor in a remote database SYNOPSIS dblink_fetch(text cursorname, int howmany[, bool fail_on_error]) returns setof record dblink_fetch(text connname, text cursorname, int howmany[, bool fail_on_error]) returns setof record DESCRIPTION dblink_fetch fetches rows from a cursor previously established by dblink_open. ARGUMENTS connname Name of the connection to use; omit this…
NAME dblink_exec – executes a command in a remote database SYNOPSIS dblink_exec(text connname, text sql[, bool fail_on_error]) returns text dblink_exec(text connstr, text sql[, bool fail_on_error]) returns text dblink_exec(text sql[, bool fail_on_error]) returns text DESCRIPTION dblink_exec executes a command (that is, any SQL statement that doesn’t return rows) in a remote database. When two text arguments…
NAME dblink_error_message – gets last error message on the named connection SYNOPSIS dblink_error_message(text connname) returns text DESCRIPTION dblink_error_message fetches the most recent remote error message for a given connection. ARGUMENTS connname Name of the connection to use. RETURN VALUE Returns last error message, or an empty string if there has been no error in this…
NAME dblink_disconnect – closes a persistent connection to a remote database SYNOPSIS dblink_disconnect() returns text dblink_disconnect(text connname) returns text DESCRIPTION dblink_disconnect() closes a connection previously opened by dblink_connect(). The form with no arguments closes an unnamed connection. ARGUMENTS connname The name of a named connection to be closed. RETURN VALUE Returns status, which is always…
NAME dblink_connect_u – opens a persistent connection to a remote database, insecurely SYNOPSIS dblink_connect_u(text connstr) returns text dblink_connect_u(text connname, text connstr) returns text DESCRIPTION dblink_connect_u() is identical to dblink_connect(), except that it will allow non-superusers to connect using any authentication method. If the remote server selects an authentication method that does not involve a password,…
NAME dblink_connect – opens a persistent connection to a remote database SYNOPSIS dblink_connect(text connstr) returns text dblink_connect(text connname, text connstr) returns text DESCRIPTION dblink_connect() establishes a connection to a remote PostgreSQL database. The server and database to be contacted are identified through a standard libpq connection string. Optionally, a name can be assigned to the…
NAME dblink_close – closes a cursor in a remote database SYNOPSIS dblink_close(text cursorname[, bool fail_on_error]) returns text dblink_close(text connname, text cursorname[, bool fail_on_error]) returns text DESCRIPTION dblink_close closes a cursor previously opened with dblink_open. ARGUMENTS connname Name of the connection to use; omit this parameter to use the unnamed connection. cursorname The name of the…
NAME dblink_cancel_query – cancels any active query on the named connection SYNOPSIS dblink_cancel_query(text connname) returns text DESCRIPTION dblink_cancel_query attempts to cancel any query that is in progress on the named connection. Note that this is not certain to succeed (since, for example, the remote query might already have finished). A cancel request simply improves the…
NAME dblink_build_sql_update – builds an UPDATE statement using a local tuple, replacing the primary key field values with alternative supplied values SYNOPSIS dblink_build_sql_update(text relname, int2vector primary_key_attnums, integer num_primary_key_atts, text[] src_pk_att_vals_array, text[] tgt_pk_att_vals_array) returns text DESCRIPTION dblink_build_sql_update can be useful in doing selective replication of a local table to a remote database. It selects a row…
NAME dblink_build_sql_insert – builds an INSERT statement using a local tuple, replacing the primary key field values with alternative supplied values SYNOPSIS dblink_build_sql_insert(text relname, int2vector primary_key_attnums, integer num_primary_key_atts, text[] src_pk_att_vals_array, text[] tgt_pk_att_vals_array) returns text DESCRIPTION dblink_build_sql_insert can be useful in doing selective replication of a local table to a remote database. It selects a row…
NAME dblink_build_sql_delete – builds a DELETE statement using supplied values for primary key field values SYNOPSIS dblink_build_sql_delete(text relname, int2vector primary_key_attnums, integer num_primary_key_atts, text[] tgt_pk_att_vals_array) returns text DESCRIPTION dblink_build_sql_delete can be useful in doing selective replication of a local table to a remote database. It builds a SQL DELETE command that will delete the row with…
NAME dblink – executes a query in a remote database SYNOPSIS dblink(text connname, text sql[, bool fail_on_error]) returns setof record dblink(text connstr, text sql[, bool fail_on_error]) returns setof record dblink(text sql[, bool fail_on_error]) returns setof record DESCRIPTION dblink executes a query (usually a SELECT, but it can be any SQL statement that returns rows) in…
dbdsqr.f – Synopsis Functions/Subroutines subroutine dbdsqr (UPLO, N, NCVT, NRU, NCC, D, E, VT, LDVT, U, LDU, C, LDC, WORK, INFO) DBDSQR Function/Subroutine Documentation subroutine dbdsqr (characterUPLO, integerN, integerNCVT, integerNRU, integerNCC, double precision, dimension( * )D, double precision, dimension( * )E, double precision, dimension( ldvt, * )VT, integerLDVT, double precision, dimension( ldu, * )U, integerLDU,…
dbdsdc.f – Synopsis Functions/Subroutines subroutine dbdsdc (UPLO, COMPQ, N, D, E, U, LDU, VT, LDVT, Q, IQ, WORK, IWORK, INFO) DBDSDC Function/Subroutine Documentation subroutine dbdsdc (characterUPLO, characterCOMPQ, integerN, double precision, dimension( * )D, double precision, dimension( * )E, double precision, dimension( ldu, * )U, integerLDU, double precision, dimension( ldvt, * )VT, integerLDVT, double precision, dimension(…
dbbcsd.f – Synopsis Functions/Subroutines subroutine dbbcsd (JOBU1, JOBU2, JOBV1T, JOBV2T, TRANS, M, P, Q, THETA, PHI, U1, LDU1, U2, LDU2, V1T, LDV1T, V2T, LDV2T, B11D, B11E, B12D, B12E, B21D, B21E, B22D, B22E, WORK, LWORK, INFO) DBBCSD Function/Subroutine Documentation subroutine dbbcsd (characterJOBU1, characterJOBU2, characterJOBV1T, characterJOBV2T, characterTRANS, integerM, integerP, integerQ, double precision, dimension( * )THETA, double precision,…