Postgres-XC 1.1 Documentation
Prev
Up
Chapter 44. Server Programming Interface
Next
44.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