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