Man Pages in
postgresql-doc-9.4
Carta.tech
Packages
postgresql-doc-9.4
63
Section 3:
Library calls
SPI_connect.3
Connect a procedure 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_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_plan.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 procedure 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_pop.3
Pop spi stack to return from recursive spi usage
SPI_prepare.3
Prepare a statement, without executing it yet
SPI_prepare_cursor.3
Prepare a statement, without executing it yet
SPI_prepare_params.3
Prepare a statement, without executing it yet
SPI_push.3
Push spi stack to allow recursive spi usage
SPI_repalloc.3
Reallocate memory in the upper executor context
SPI_returntuple.3
Prepare to return a tuple as a datum
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
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 relations 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