section 3pg16 · Library functions 📚

D

• dblink(3pg16)executes a query in a remote database✨
• dblink_build_sql_delete(3pg16)builds a DELETE statement using supplied values for primary key field values✨
• dblink_build_sql_insert(3pg16)builds an INSERT statement using a local tuple, replacing the primary key field values with alternative supplied values✨
• dblink_build_sql_update(3pg16)builds an UPDATE statement using a local tuple, replacing the primary key field values with alternative supplied values✨
• dblink_cancel_query(3pg16)cancels any active query on the named connection✨
• dblink_close(3pg16)closes a cursor in a remote database✨
• dblink_connect(3pg16)opens a persistent connection to a remote database✨
• dblink_connect_u(3pg16)opens a persistent connection to a remote database, insecurely✨
• dblink_disconnect(3pg16)closes a persistent connection to a remote database✨
• dblink_error_message(3pg16)gets last error message on the named connection✨
• dblink_exec(3pg16)executes a command in a remote database✨
• dblink_fetch(3pg16)returns rows from an open cursor in a remote database✨
• dblink_get_connections(3pg16)returns the names of all open named dblink connections✨
• dblink_get_notify(3pg16)retrieve async notifications on a connection✨
• dblink_get_pkey(3pg16)returns the positions and field names of a relation's primary key fields✨
• dblink_get_result(3pg16)gets an async query result✨
• dblink_is_busy(3pg16)checks if connection is busy with an async query✨
• dblink_open(3pg16)opens a cursor in a remote database✨
• dblink_send_query(3pg16)sends an async query to a remote database✨

S

• SPI_commit(3pg16)commit the current transaction✨
• SPI_connect(3pg16)connect a C function to the SPI manager✨
• SPI_copytuple(3pg16)make a copy of a row in the upper executor context✨
• SPI_cursor_close(3pg16)close a cursor✨
• SPI_cursor_fetch(3pg16)fetch some rows from a cursor✨
• SPI_cursor_find(3pg16)find an existing cursor by name✨
• SPI_cursor_move(3pg16)move a cursor✨
• SPI_cursor_open(3pg16)set up a cursor using a statement created with SPI_prepare✨
• SPI_cursor_open_with_args(3pg16)set up a cursor using a query and parameters✨
• SPI_cursor_open_with_paramlist(3pg16)set up a cursor using parameters✨
• SPI_cursor_parse_open(3pg16)set up a cursor using a query string and parameters✨
• SPI_exec(3pg16)execute a read/write command✨
• SPI_execp(3pg16)execute a statement in read/write mode✨
• SPI_execute(3pg16)execute a command✨
• SPI_execute_extended(3pg16)execute a command with out-of-line parameters✨
• SPI_execute_plan(3pg16)execute a statement prepared by SPI_prepare✨
• SPI_execute_plan_extended(3pg16)execute a statement prepared by SPI_prepare✨
• SPI_execute_plan_with_paramlist(3pg16)execute a statement prepared by SPI_prepare✨
• SPI_execute_with_args(3pg16)execute a command with out-of-line parameters✨
• SPI_finish(3pg16)disconnect a C function from the SPI manager✨
• SPI_fname(3pg16)determine the column name for the specified column number✨
• SPI_fnumber(3pg16)determine the column number for the specified column name✨
• SPI_freeplan(3pg16)free a previously saved prepared statement✨
• SPI_freetuple(3pg16)free a row allocated in the upper executor context✨
• SPI_freetuptable(3pg16)free a row set created by SPI_execute or a similar function✨
• SPI_getargcount(3pg16)return the number of arguments needed by a statement prepared by SPI_prepare✨
• SPI_getargtypeid(3pg16)return the data type OID for an argument of a statement prepared by SPI_prepare✨
• SPI_getbinval(3pg16)return the binary value of the specified column✨
• SPI_getnspname(3pg16)return the namespace of the specified relation✨
• SPI_getrelname(3pg16)return the name of the specified relation✨
• SPI_gettype(3pg16)return the data type name of the specified column✨
• SPI_gettypeid(3pg16)return the data type OID of the specified column✨
• SPI_getvalue(3pg16)return the string value of the specified column✨
• SPI_is_cursor_plan(3pg16)return true if a statement prepared by SPI_prepare can be used with SPI_cursor_open✨
• SPI_keepplan(3pg16)save a prepared statement✨
• SPI_modifytuple(3pg16)create a row by replacing selected fields of a given row✨
• SPI_palloc(3pg16)allocate memory in the upper executor context✨
• SPI_pfree(3pg16)free memory in the upper executor context✨
• SPI_prepare(3pg16)prepare a statement, without executing it yet✨
• SPI_prepare_cursor(3pg16)prepare a statement, without executing it yet✨
• SPI_prepare_extended(3pg16)prepare a statement, without executing it yet✨
• SPI_prepare_params(3pg16)prepare a statement, without executing it yet✨
• SPI_register_relation(3pg16)make an ephemeral named relation available by name in SPI queries✨
• SPI_register_trigger_data(3pg16)make ephemeral trigger data available in SPI queries✨
• SPI_repalloc(3pg16)reallocate memory in the upper executor context✨
• SPI_result_code_string(3pg16)return error code as string✨
• SPI_returntuple(3pg16)prepare to return a tuple as a Datum✨
• SPI_rollback(3pg16)abort the current transaction✨
• SPI_saveplan(3pg16)save a prepared statement✨
• SPI_scroll_cursor_fetch(3pg16)fetch some rows from a cursor✨
• SPI_scroll_cursor_move(3pg16)move a cursor✨
• SPI_start_transaction(3pg16)obsolete function✨
• SPI_unregister_relation(3pg16)remove an ephemeral named relation from the registry✨