#include <stdio.h>
#include <stdlib.h>
#include <libpq-fe.h>                                   
         
        int
        main()
        {
            char        state_code[3];                         
            char        query_string[256];                    
            PGconn     *conn;                                
            PGresult   *res;                               
            int         i;
        
	    conn = PQconnectStart("user=postgres,dbname=krishna");
        
		switch(PQstatus(conn))
		{
			case CONNECTION_MADE:
				printf("Connection established\n");
				break;
			case CONNECTION_BAD:
				printf("Connection error\n");
				break;
			default:
				printf("No choice\n");
		}
         
            sprintf(query_string,"SELECT * from prasad");
         
   	    res = PQexec (conn,query_string);
	   	
         
            if (PQresultStatus(res) != PGRES_TUPLES_OK)         
            {
                fprintf(stderr, "SELECT query failed.\n");
                PQclear(res);
                PQfinish(conn);
                exit(1);
            }
         
            for (i = 0; i < PQntuples(res); i++)                
                printf("%s\n", PQgetvalue(res, i, 0));          
         
            PQclear(res);                                       
         
            PQfinish(conn);                                   
         
            return 0;
        } 
