How can I retrieve double or int data type for libpq

Hi

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