Poco::Data

namespace PostgreSQL

Overview

Classes: Binder, ConnectionException, Connector, Extractor, InputParameter, OutputParameter, PGCancelFree, PQConnectionInfoOptionsFree, PQResultClear, PostgreSQLException, PostgreSQLStatementImpl, SessionHandle, SessionImpl, SessionParameters, StatementException, StatementExecutor, TransactionException, Utility

Types Aliases: InputParameterVector, OutputParameterVector, SessionParametersMap

Functions: oidToColumnDataType

Classes

class Binder

Binds INPUT (only) placeholders in the sql query to the provided values. 

class ConnectionException

ConnectionException 

class Connector

Connector instantiates PostgreSQL SessionImpl objects. 

class Extractor

Extracts and converts data values from the result row returned by PostgreSQL

class InputParameter

PostgreSQL class to record values for input parameters to SQL statements 

class OutputParameter

PostgreSQL class to record values for output parameters to capture the results 

class PGCancelFree

PostgreSQL Cancel Info Options free (RAII) 

class PQConnectionInfoOptionsFree

PostgreSQL connection Info Options free (RAII) 

class PQResultClear

PostgreSQL statement result free (RAII) 

class PostgreSQLException

Base class for all PostgreSQL exceptions 

class PostgreSQLStatementImpl

Implements statement functionality needed for PostgreSQL 

class SessionHandle

PostgreSQL connection(session) handle 

class SessionImpl

Implements SessionImpl interface 

class SessionParameters

PostgreSQL session parameters 

class StatementException

StatementException 

class StatementExecutor

PostgreSQL statement executor. 

class TransactionException

TrabsactionException 

class Utility

Various utility functions for PostgreSQL

Types Aliases

InputParameterVector

using InputParameterVector = std::vector < InputParameter >;

OutputParameterVector

using OutputParameterVector = std::vector < OutputParameter >;

SessionParametersMap

using SessionParametersMap = std::map < std::string, SessionParameters >;

Functions

oidToColumnDataType

Poco::Data::MetaColumn::ColumnDataType oidToColumnDataType(
    const Oid anOID
);

Variables

BITOID

const Oid BITOID = 1560;

BOOLOID

const Oid BOOLOID = 16;

BPCHAROID

const Oid BPCHAROID = 1042;

BYTEAOID

const Oid BYTEAOID = 17;

CASHOID

const Oid CASHOID = 790;

CHAROID

const Oid CHAROID = 18;

DATEOID

const Oid DATEOID = 1082;

FLOAT4OID

const Oid FLOAT4OID = 700;

FLOAT8OID

const Oid FLOAT8OID = 701;

INT2OID

const Oid INT2OID = 21;

INT4OID

const Oid INT4OID = 23;

INT8OID

const Oid INT8OID = 20;

MACADDROID

const Oid MACADDROID = 829;

NUMERICOID

const Oid NUMERICOID = 1700;

TEXTOID

const Oid TEXTOID = 25;

TIMEOID

const Oid TIMEOID = 1083;

TIMESTAMPOID

const Oid TIMESTAMPOID = 1114;

TIMESTAMPZOID

const Oid TIMESTAMPZOID = 1184;

TIMETZOID

const Oid TIMETZOID = 1266;

UUIDOID

const Oid UUIDOID = 2950;

VARCHAROID

const Oid VARCHAROID = 1043;

VARYBITOID

const Oid VARYBITOID = 1562;

Securely control IoT edge devices from anywhere   Connect a Device