On 06.07.21 13:04, Sudheer H R wrote:
> I am trying to use libpq for interfacing with PostgreSQL from a C/C++ based application.
>
> I have tried to use binary format of data for both sending and receiving data to and from server (resultFormat = 1).
>
> As I understand most binary types, int, float etc… are encoded in bing-endian byte order and they can be converted to
appropriatehost specific memory representations.
>
> However NUMERIC datatype is a more complex structure with multiple ints and pointers.
>
> I would like to know if there are published library functions that convert (to and from) NUMERIC field to say, long
doubledatatype
There is a third-party library called libpqtypes out there that adds
support for handling specific types on the libpq side. But I'm not sure
how up to date it is.