一个菜鸟的求救

marco_chan

哪位大侠可以帮我贴一个简单的，用C访问postgre进行insert或者delete操作的实例代码。。。。。。。。。。。。。。。。。本人将感激不尽

linux_prog

#include <stdio.h>;
#include <stdlib.h>;
#include <libpq-fe.h>;

int main(int argc,char **argv)
{
   PGconn *conn;
   PGresult *res;
   char *pghost ="localhost";
   char *pgport ="5432";
   char *pgoptions ="username=postgresql";
   char *pgtty = NULL;
   char *dbname ="postgresql";/**数据库名*/
   char filename[1024];
   char sql[1024];
   memset(filename,0,sizeof(filename));
   memset(sql,0,sizeof(sql));
   snprintf(filename,sizeof(filename),"%s",argv[1]);
   snprintf(sql,sizeof(sql),"insert into bookinfo values('%s','%s','%s','%s',1024)",filename,filename,filename,filename);
   //conn = PQsetdb(pghost,pgport,pgoptions,pgtty,dbname);
   conn=PQconnectdb("host=localhost port=5432 dbname=postgresql user=postgresql password=0zss6be7";
   if (PQstatus(conn)==CONNECTION_BAD)
   {
      fprintf(stderr,"Connection to database '%s' failed!\n",dbname);
      PQfinish(conn);
          exit(10);
     }
    res = PQexec(conn,sql);
     if(PQresultStatus(res)!=PGRES_COMMAND_OK)
     {
       fprintf(stderr,"Exec Query Fauled!\n";
       PQclear(res);
           exit(11);
       }
     PQfinish(conn);
     PQclear(res);
         unlink(filename);
     exit(0);
}