1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55
|
#include <stdio.h>
#include <stdlib.h>
#include <string.h>
#include <sys/types.h>
#include <dirent.h>
#include <ctype.h>
#include <libpq-fe.h>
#include <time.h>
void main()
{
int i=0;
int j=0;
int nbfields,nbtuples;
PGconn *conn;
const char *conninfo;
conn = PQsetdbLogin("192.168.xx.xx","5432","","","antoine","antoine","antoine");
if (PQstatus(conn)!=CONNECTION_OK)
{
fprintf(stderr,"%s",PQerrorMessage(conn));
}
else
{
printf("connection réussie\n");
}
PGresult* res;
res=PQexec(conn,"BEGIN");
PQclear(res);
res=PQexec(conn,"select * from dservers");
if(res==NULL)
{
fprintf(stderr,"echec de select");
}
nbfields=PQnfields(res);
nbtuples=PQntuples(res);
for(i=0;i<nbfields;i++)
{
printf("%s\n",PQfname(res,i));
for(j=0;j<nbtuples;j++)
{
printf("%s\n",PQgetvalue(res,j,i));
}
}
PQclear(res);
res=PQexec(conn,"insert into dservers(ip,pays,nb_users,nb_files) values('192','fr','007','009')");
PQfinish(conn);
} |
Partager