Using binary parameters and results is more efficient, but is currently cumbersome and requires the developer to understand the backend binary formats. libpqtypes abstracts the libpq user from the binary formats of data types, allowing them to simply put or get data in a printf/scanf style interface.
Full support for binary and text format (parameter and result)
Full support for composites, arrays and composite arrays. (binary format only)
printf style interface to libpq's binary parameterized API. PQputf
scanf style interface for getting values: PQgetvalue extension. PQgetf
Ability to register user-defined types, aliases and data type
sub-classes for use with printf style interfaces: ex. "%mytype". PQregisterTypeHandler
Per-thread global error message: PQgeterror, PQseterror.
Online docs as well as man pages.
Questions, comments, bugs, etc...
Andrew Chernow & Merlin Moncure
Contributed by eSilo, LLC. for the PostgreSQL Community
This post has been migrated from a previous version of the PostgreSQL website. We apologise for any formatting issues caused by the migration.