📦 postgresql-doc-16

75 pages

D

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

S

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