uPg provides data type support with a system of buffer parsers and formatters. Please refer to pg_io for more information about the system.
The fundamental PostgreSQL types support is provided by the driver. The table below shows supported Postgres types and their mapping to C++ types provided by the driver. Column "Default" marks the Postgres type to which a C++ type is mapped when used as a parameter. Where the C++ type is N/A it means that the PosgreSQL data type is not supported. When there is a C++ type in parenthesis, it is a data type that will be supported later and the C++ type is planned counterpart.
PG type | C++ type | Default |
---|---|---|
smallint | std::int16_t | + |
integer | std::int32_t | + |
bigint | std::int64_t | + |
smallserial | std::int16_t | |
serial | std::int32_t | |
bigserial | std::int64_t | |
boolean | bool | + |
real | float | + |
double precision | double | + |
numeric(p) | decimal64::Decimal | + |
decimal(p) | decimal64::Decimal | + |
money | N/A | |
text | std::string | + |
char(n) | std::string | |
varchar(n) | std::string | |
"char" | char | + |
timestamp | std::chrono::system_clock::time_point | + |
timestamptz | storages::postgres::TimePointTz | + |
date | utils::datetime::Date | + |
time | utils::datetime::TimeOfDay | + |
timetz | N/A | |
interval | std::chrono::microseconds | |
bytea | container of one-byte type | |
bit(n) | utils::Flags | |
std::bitset<N> | ||
std::array<bool, N> | ||
bit varying(n) | utils::Flags | |
std::bitset<N> | ||
std::array<bool, N> | ||
uuid | boost::uuids::uuid | + |
json | formats::json::Value | |
jsonb | formats::json::Value | + |
int4range | storages::postgres::IntegerRange | |
storages::postgres::BoundedIntegerRange | ||
int8range | storages::postgres::BigintRange | |
storages::postgres::BoundedBigintRange | ||
inet | utils::ip::AddressV4 | |
utils::ip::AddressV6 | ||
cidr | utils::ip::NetworkV4 | |
utils::ip::NetworkV6 | ||
macaddr | utils::Macaddr | |
macaddr8 | utils::Macaddr8 | |
numrange | N/A | |
tsrange | N/A | |
tstzrange | N/A | |
daterange | N/A |
For more information on timestamps and working with time zones please see uPg timestamp support
The driver supports PostgreSQL arrays provided that the element type is supported by the driver, including user types.
Array parser will throw storages::postgres::DimensionMismatch if the dimensions of C++ container do not match that of the buffer received from the server.
Array formatter will throw storages::postgres::InvalidDimensions if containers on same level of depth have different sizes.
The driver provides support for user-defined PostgreSQL types:
For more information please see uPg: PostgreSQL user type mappings.
The driver provides support for C++ strong typedef idiom. For more information see uPg: support for C++ 'strong typedef' idiom
PostgreSQL range type support is provided by storages::postgres::Range
template.
For geometry types the driver provides parsing/formatting from/to on-the-wire representation. The types provided do not define any calculus.
The driver allows reading and writing raw binary data from/to PostgreSQL bytea
type.
Reading and writing to PostgreSQL is implemented for std::string
, std::string_view
and std::vector
of char
or unsigned char
.
std::string_view
the value MUST NOT be used after the PostgreSQL result set is destroyed.The driver offers data types to store IPv4, IPv6, and MAC addresses, as well as network specifications (CIDR).
The driver supports PostgreSQL bit
and bit varying
types.
Parsing and formatting is implemented for integral values (e.g. uint32_t
, uint64_t
), utils::Flags
, std::array<bool, N>
and std::bitset<N>
.
Example of using the bit types from tests:
The types not covered above or marked as N/A in the table of fundamental types will be eventually supported later, on request from the driver's users.