Postgres C API
Select all rows
// Select all rows
{
res = PQexec(cnxn, "select x, s from A");
for (int r = 0; r < PQntuples(res); r++) {
for (int c = 0; c < PQnfields(res); c++) {
if (PQgetisnull(res, r, c)) {
printf("NULL\t");
} else {
char* field = PQgetvalue(res, r, c);
printf("%s\t", field);
}
}
printf("\n");
}
printf("Rows selected: %s\n", PQcmdTuples(res));
PQclear(res);
}
|