help:steps needed to get the content of table from the database.. .

Hi all...
I am using libpq interface to create a C application which is taking the
needed data from
a database....

I created a database and added 3 tables to it named weather, cities and
teamdatabase.
I make the connection with database ...
After that i tried to execute the command SELECT * FROM weather by giving as
res = PQexec(conn,"SELECT * FROM weather");

what are the steps needed to get the content of table from the database...

can any one of you give me few guide lines....

Thanking in advance
With regards
smitha

*********************************************************************
Disclaimer: The information in this e-mail and any attachments is
confidential / privileged. It is intended solely for the addressee or
addressees. If you are not the addressee indicated in this message, you may
not copy or deliver this message to anyone. In such case, you should destroy
this message and kindly notify the sender by reply email. Please advise
immediately if you or your employer does not consent to Internet email for
messages of this kind.
*********************************************************************