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
|
#include <stdio.h>
#include <dbi/dbi.h>
int main() {
dbi_conn conn;
dbi_result result;
dbi_inst instance;
dbi_initialize_r(NULL, &instance);
conn = dbi_conn_new_r("pgsql", instance);
dbi_conn_set_option(conn, "host", "localhost");
if (dbi_conn_connect(conn) < 0)
exit(0);
else
{
result = dbi_conn_query(conn, "SELECT * from table");
if (result) {
while (dbi_result_next_row(result)) {
unsigned idnumber = dbi_result_get_uint(result, "id");
}
dbi_result_free(result);
}
dbi_conn_close(conn);
}
dbi_shutdown_r(instance);
return 0;
}
|
