Template Queries

Extends Connection by adding query methods

template Queries ;

Just use it as Connection.* methods.

Contained Functions

NameDescription
describePortal Submits a request to obtain information about the specified portal, and waits for completion.
describePrepared Submits a request to obtain information about the specified prepared statement, and waits for completion.
exec Perform SQL query to DB It uses the old wire protocol and all values are returned in textual form. This means that the dpq2.conv.to_d_types.as template will likely not work for anything but strings. Try to used execParams instead, even if now parameters are present.
execParams Perform SQL query to DB
execPrepared Submits a request to execute a prepared statement with given parameters, and waits for completion.
getNextNotify Returns null if no notifies was received
prepare Submits a request to create a prepared statement with the given parameters, and waits for completion.
prepareEx Submits a request to create a prepared statement with the given parameters, and waits for completion.
putCopyData Sends a buffer of CSV data to the COPY command
putCopyEnd Signals that COPY data send is finished. Finalize and flush the COPY command.
sendDescribePrepared Submits a request to obtain information about the specified prepared statement, without waiting for completion.
sendPrepare Sends a request to create a prepared statement with the given parameters, without waiting for completion.
sendPutCopyEnd Signals that COPY data send is finished.
sendQuery Submits a command to the server without waiting for the result(s)
sendQueryParams Submits a command and separate parameters to the server without waiting for the result(s)
sendQueryPrepared Sends a request to execute a prepared statement with given parameters, without waiting for the result(s)