Search PostgreSQL documentation

ArgumentsManual ChaptersPG18Arguments connname Name of the connection to use; omit this parameter to use the unnamed connection. connstr A connection info string, as previously described for dblink_connect. sql The SQL…Arguments ArgumentsManual ChaptersPG18Arguments connname The name of a named connection to get notifications on.Arguments ArgumentsManual ChaptersPG18Arguments relname Name of a local relation, for example foo or myschema.mytab. Include double quotes if the name is mixed-case or contains special characters, for example "FooBar"; without q…Arguments ArgumentsManual ChaptersPG18Arguments connname Name of the connection to use. fail_on_error If true (the default when omitted) then an error thrown on the remote side of the connection causes an error to also be thrown…Arguments ArgumentsManual ChaptersPG18Arguments connname Name of the connection to check.Arguments ArgumentsManual ChaptersPG18Arguments connname Name of the connection to use; omit this parameter to use the unnamed connection. cursorname The name to assign to this cursor. sql The SELECT statement that you wish to e…Arguments ArgumentsManual ChaptersPG18Arguments connname Name of the connection to use. sql The SQL statement that you wish to execute in the remote database, for example select * from pg_class.Arguments ArgumentsManual ChaptersPG18Arguments void * pointer pointer to existing storage to change Size size size in bytes of storage to allocateArguments ArgumentsManual ChaptersPG18Arguments HeapTuple row row to be copiedArguments ArgumentsManual ChaptersPG18Arguments Portal portal portal containing the cursorArguments ArgumentsManual ChaptersPG18Arguments Portal portal portal containing the cursor bool forward true for fetch forward, false for fetch backward long count maximum number of rows to fetchArguments ArgumentsManual ChaptersPG18Arguments const char * name name of the portalArguments ArgumentsManual ChaptersPG18Arguments Portal portal portal containing the cursor bool forward true for move forward, false for move backward long count maximum number of rows to moveArguments ArgumentsManual ChaptersPG18Arguments const char * name name for portal, or NULL to let the system select a name const char * command command string int nargs number of input parameters ($1, $2, etc.) Oid * argtypes an…Arguments ArgumentsManual ChaptersPG18Arguments const char * name name for portal, or NULL to let the system select a name SPIPlanPtr plan prepared statement (returned by SPI_prepare) ParamListInfo params data structure containi…Arguments ArgumentsManual ChaptersPG18Arguments const char * name name for portal, or NULL to let the system select a name SPIPlanPtr plan prepared statement (returned by SPI_prepare) Datum * values An array of actual parameter …Arguments ArgumentsManual ChaptersPG18Arguments const char * name name for portal, or NULL to let the system select a name const char * command command string const SPIParseOpenOptions * options struct containing optional argume…Arguments ArgumentsManual ChaptersPG18Arguments const char * command string containing command to execute long count maximum number of rows to return, or 0 for no limitArguments ArgumentsManual ChaptersPG18Arguments SPIPlanPtr plan prepared statement (returned by SPI_prepare) Datum * values An array of actual parameter values. Must have same length as the statement's number of arguments. const…Arguments ArgumentsManual ChaptersPG18Arguments const char * command command string const SPIExecuteOptions * options struct containing optional arguments Callers should always zero out the entire options struct, then fill which…Arguments ArgumentsManual ChaptersPG18Arguments SPIPlanPtr plan prepared statement (returned by SPI_prepare) const SPIExecuteOptions * options struct containing optional arguments Callers should always zero out the entire option…Arguments ArgumentsManual ChaptersPG18Arguments SPIPlanPtr plan prepared statement (returned by SPI_prepare) ParamListInfo params data structure containing parameter types and values; NULL if none bool read_only true for read-on…Arguments ArgumentsManual ChaptersPG18Arguments SPIPlanPtr plan prepared statement (returned by SPI_prepare) Datum * values An array of actual parameter values. Must have same length as the statement's number of arguments. const…Arguments ArgumentsManual ChaptersPG18Arguments const char * command command string int nargs number of input parameters ($1, $2, etc.) Oid * argtypes an array of length nargs, containing the OIDs of the data types of the parame…Arguments ArgumentsManual ChaptersPG18Arguments const char * command string containing command to execute bool read_only true for read-only execution long count maximum number of rows to return, or 0 for no limitArguments ArgumentsManual ChaptersPG18Arguments TupleDesc rowdesc input row description int colnumber column number (count starts at 1)Arguments ArgumentsManual ChaptersPG18Arguments TupleDesc rowdesc input row description const char * colname column nameArguments ArgumentsManual ChaptersPG18Arguments SPIPlanPtr plan pointer to statement to freeArguments ArgumentsManual ChaptersPG18Arguments HeapTuple row row to freeArguments ArgumentsManual ChaptersPG18Arguments SPITupleTable * tuptable pointer to row set to free, or NULL to do nothingArguments ArgumentsManual ChaptersPG18Arguments SPIPlanPtr plan prepared statement (returned by SPI_prepare)Arguments ArgumentsManual ChaptersPG18Arguments SPIPlanPtr plan prepared statement (returned by SPI_prepare) int argIndex zero based index of the argumentArguments ArgumentsManual ChaptersPG18Arguments HeapTuple row input row to be examined TupleDesc rowdesc input row description int colnumber column number (count starts at 1) bool * isnull flag for a null value in the columnArguments ArgumentsManual ChaptersPG18Arguments Relation rel input relationArguments ArgumentsManual ChaptersPG18Arguments Relation rel input relationArguments ArgumentsManual ChaptersPG18Arguments TupleDesc rowdesc input row description int colnumber column number (count starts at 1)Arguments ArgumentsManual ChaptersPG18Arguments TupleDesc rowdesc input row description int colnumber column number (count starts at 1)Arguments ArgumentsManual ChaptersPG18Arguments HeapTuple row input row to be examined TupleDesc rowdesc input row description int colnumber column number (count starts at 1)Arguments ArgumentsManual ChaptersPG18Arguments SPIPlanPtr plan prepared statement (returned by SPI_prepare)Arguments ArgumentsManual ChaptersPG18Arguments SPIPlanPtr plan the prepared statement to be savedArguments