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 +47.1. Interface Functions 47.1. Interface Functions Prev Up Chapter 47. Server Programming Interface Home Next 47.1. Interface Functions 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 \ No newline at end of file + 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