PostgreSQL 9.2.3 Documentation
Prev | Up | Chapter 43. Server Programming Interface | Next

# 43.1. Interface Functions

Table of Contents
SPI_connect -- connect a procedure to the SPI manager
SPI_finish -- disconnect a procedure from the SPI manager
SPI_push -- push SPI stack to allow recursive SPI usage
SPI_pop -- pop SPI stack to return from recursive SPI usage
SPI_execute -- execute a command
SPI_exec -- execute a read/write command
SPI_execute_with_args -- execute a command with out-of-line parameters
SPI_prepare -- prepare a statement, without executing it yet
SPI_prepare_cursor -- prepare a statement, without executing it yet
SPI_prepare_params -- prepare a statement, without executing it yet
SPI_getargcount -- return the number of arguments needed by a statement prepared by `SPI_prepare`
SPI_getargtypeid -- return the data type OID for an argument of a statement prepared by `SPI_prepare`
SPI_is_cursor_plan -- return `true` if a statement prepared by `SPI_prepare` can be used with `SPI_cursor_open`
SPI_execute_plan -- execute a statement prepared by `SPI_prepare`
SPI_execute_plan_with_paramlist -- execute a statement prepared by `SPI_prepare`
SPI_execp -- execute a statement in read/write mode
SPI_cursor_open -- set up a cursor using a statement created with `SPI_prepare`
SPI_cursor_open_with_args -- set up a cursor using a query and parameters
SPI_cursor_open_with_paramlist -- set up a cursor using parameters
SPI_cursor_find -- find an existing cursor by name
SPI_cursor_fetch -- fetch some rows from a cursor
SPI_cursor_move -- move a cursor
SPI_scroll_cursor_fetch -- fetch some rows from a cursor
SPI_scroll_cursor_move -- move a cursor
SPI_cursor_close -- close a cursor
SPI_keepplan -- save a prepared statement
SPI_saveplan -- save a prepared statement

Prev | Home | Next
Server Programming Interface | Up | SPI_connect