Interface Functions
| PostgreSQL 9.6.8 Documentation | |||
|---|---|---|---|
| Prev | Up | Chapter 45. Server Programming Interface | Next |
- 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_preparecan be used withSPI_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