PostgreSQL 9.6.2 문서
이전
위로
장 45. Server Programming Interface
다음
45.1. Interface Functions
차례
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
이전
처음으로
다음
Server Programming Interface
위로
SPI_connect