24th September 2020: PostgreSQL 13 Released!

libpqtypes Initial Release

Posted on 2008-05-08

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.

Online Documentation:


Project Page:


Questions, comments, bugs, etc...


Maintainers Contact:


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.