Updated on 2024-06-03 GMT+08:00

PQexecPreparedBatch

Function

PQexecPreparedBatch is used to send a request to execute a prepared statement with batches of given parameters and wait for the result.

Prototype

PGresult* PQexecPreparedBatch(PGconn* conn, 
                              const char* stmtName, 
                              int nParams,
                              int nBatchCount,
                              const char* const* paramValues,
                              const int* paramLengths,
                              const int* paramFormats,
                              int resultFormat);

Parameter

Table 1 PQexecPreparedBatch parameters

Keyword

Parameter Description

conn

Connection handle.

stmtName

stmt name, which can be set to "" or NULL to reference an unnamed statement. Otherwise, it must be the name of an existing prepared statement.

nParams

Parameter quantity.

nBatchCount

Number of batches.

paramValues

Actual values of parameters.

paramLengths

Actual data lengths of parameters.

paramFormats

Parameter formats (text or binary).

resultFormat

Return result format (text or binary).

Return Value

PGresult pointers