Re: Select statement error !!!! - Mailing list pgsql-docs
From | Vutharkar Goutham |
---|---|
Subject | Re: Select statement error !!!! |
Date | |
Msg-id | Sea1-F145GKvt87AM7t0001f343@hotmail.com Whole thread Raw |
In response to | Select statement error !!!! ("Vutharkar Goutham" <goutham4u@hotmail.com>) |
Responses |
Re: Select statement error !!!!
|
List | pgsql-docs |
Hello, I am sorry that this isn't the right group to putup the question but i am desperate to get it right and moreover thats what the major hindrance to our project. We are doing Intrusion Detection System as project to fulfill the requirement of completion of Post Graduation in MSIT. So we are using PostgreSQL as our database to store the captured data from a LAN or from outside network. So in the mean process we successfully captured the data packets and sent them into the database tables but the problem is when we are are trying to retrieve data then we are failing and we dont know how to proceed further. We searched all the forums for right answer but didn't get to it so i was forced to post here. Now let me paste the code here .... #include<stdio.h> #include<libpq-fe.h> void exit_nicely(PGconn *conn) { PQfinish(conn); exit(1); } int main() { char *pghost,*pgport,*pgoptions,*pgtty; char *dbname; char query[1024]; struct PQprintOpt *po; int nFields; int i,j; FILE *fp; fp = fopen("data.txt","w+"); strcpy(query,"select * from UDP_Table"); printf("\nInitial Query is : %s\n",query); PGconn *conn; PGresult *res; pghost = NULL; pgport = NULL; pgoptions = NULL; pgtty = NULL; dbname = "Project"; conn = PQsetdb(pghost,pgport,pgoptions,pgtty,dbname); if(PQstatus(conn) == CONNECTION_BAD) { fprintf(stderr,"Failed to make a connection.\n",dbname); fprintf(stderr,"%s",PQerrorMessage(conn)); exit_nicely(conn); } else printf("\nConnection established with backend.\n"); res = PQexec(conn,"BEGIN"); if(!res || PQresultStatus(res)!=PGRES_TUPLES_OK) { fprintf(stderr,"Begin Failed.\n"); PQclear(res); exit_nicely(conn); } else printf("\nBegin Transaction Completed Successfully.\n"); printf("\nQuery B4 execution is : %s\n",query); res = PQexec(conn,query); if(!res || PQresultStatus(res)!=PGRES_COMMAND_OK) { fprintf(stderr,"\nSelect Statement Failed.\n"); PQclear(res); exit_nicely(conn); } else { printf("\nSelect statement executed successfully.\n"); PQprint(fp,res,(const struct PQprintOpt *)po); } // Print Attribute Names printf("\nThe Attribute Names are \n\n"); nFields = PQnfields(res); for(i = 0;i<nFields;i++) printf("%-15s",PQfname(res,i)); printf("\n\n"); //Print out rows printf("The Rows in the table are \n\n"); for(i = 0;i<PQntuples(res);i++) { for(i = 0;j<nFields;j++) printf("%-15s",PQgetvalue(res,i,j)); printf("\n"); } res = PQexec(conn,"COMMIT"); PQclear(res); PQfinish(conn); return 0; } I tried as told by you but still i failed. So please dont mind solving the problem for me if i am not troubling you. Your help will be appreciated a lot by our project team. Thank You, Goutham.V MSIT. _________________________________________________________________ Talk to Karthikeyan. Watch his stunning feats. http://server1.msn.co.in/sp03/tataracing/index.asp Download images.
pgsql-docs by date: