Thread: How can I retrieve double or int data type for libpq

How can I retrieve double or int data type for libpq

From

"a"

Date:

13 June 2018, 09:08:33

I wanna use C library to connect pgsql server and I got 2 questions:

1, If I can fetch a row's data instead of using PQgetvalue?

2, PQgetvalue will return all data as text, I would have to convert them into the relative data type, is there a way of getting data by its original format?

Thanks so much!

Shore

Re: How can I retrieve double or int data type for libpq

From

Laurenz Albe

Date:

13 June 2018, 10:29:51

a wrote:
> I wanna use C library to connect pgsql server and I got 2 questions:

This is all well documented in
https://www.postgresql.org/docs/current/static/libpq.html

> 1, If I can fetch a row's data instead of using PQgetvalue?

PGgetvalue *is* the way to fetch the row's data.

There is no call to fetch *all* columns at once, but that is
not necessary.

> 2, PQgetvalue will return all data as text, I would have to convert them into the
> relative data type, is there a way of getting data by its original format?

You will get the data in binary form if you specify a resultFormat of 1
with PQexecParams.

Note, however, that they will be in the native binary format of the *server*.

Yours,
Laurenz Albe
-- 
Cybertec | https://www.cybertec-postgresql.com