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
|
#include <stdio.h>
#include <time.h>
#include <libpq-fe.h>
#include "main.h"
int main(int argc, char *argv[]) {
PGconn *conn;
char SQL_query[512];
PGresult *res;
int ntuples, nfields;
int i, j;
conn = PQsetdbLogin(PGHOST, PGPORT, PGOPTIONS, PGTTY, DBNAME, LOGIN, PWD);
if(CONNECTION_BAD == PQstatus(conn))
{
fprintf(stderr, "Connection to database '%s' failed.\n %s", DBNAME, PQerrorMessage(conn));
PQfinish(conn);
return 1;
}
sprintf(SQL_query, "SELECT * FROM testicle");
res = PQexec(conn, SQL_query);
if(res == NULL || PQresultStatus(res) != PGRES_TUPLES_OK)
{
printf("Unable to execute query: %s\n %s\n", SQL_query, PQerrorMessage(conn));
}
else
{
ntuples = PQntuples(res);
nfields = PQnfields(res);
for (i = 0; i < ntuples; i++)
{
for (j = 0; j < nfields; j++)
{
printf("Query result: %s - %s\n", PQfname(res, j), PQgetvalue(res, i, j));
}
}
}
PQclear(res);
PQfinish(conn);
return 0;
}
|