47.1. Interface Functions

47.1. Interface Functions
Prev	Up	Chapter 47. Server Programming Interface	Home	Next

SPI_connect - connect a C function to the SPI manager
SPI_finish - disconnect a C function from the SPI manager
SPI_execute - execute a command
SPI_exec - execute a read/write command
SPI_execute_extended - execute a command with out-of-line parameters
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_extended - 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_extended - 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_parse_open - set up a cursor using a query string and 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
SPI_register_relation - make an ephemeral named relation available by name in SPI queries
SPI_unregister_relation - remove an ephemeral named relation from the registry
SPI_register_trigger_data - make ephemeral trigger data available in SPI queries

Prev	Up	Next
Chapter 47. Server Programming Interface	Home	SPI_connect