#include <iostream>

//using namespace std;

#include <stdio.h>
#include "libpq-fe.h"
#include <string>
#include <cstdio>
#include <stdlib.h>


int main() {
PGconn *conn;
PGresult *res;
int rec_count;
FILE *stream;

conn = PQconnectdb("hostaddr=192.168.1.8 port=5432 connect_timeout=10 dbname=NexentaSearch user=postgres password=valter89");
if (PQstatus(conn) == CONNECTION_BAD) {
fprintf(stderr, "Connection to database failed: %s\n",PQerrorMessage(conn));
puts("No connection");
exit(0);
}

res = PQexec(conn, "SELECT a.value, c.value FROM therms a INNER JOIN therms_occurs b ON b.therm_id = a.id INNER JOIN fs_entries c ON b.file_id = c.id ORDER BY a.value, c.value");

if (PQresultStatus(res) != PGRES_TUPLES_OK) {
printf("We didn't get the data");
exit(0);
}

rec_count = PQntuples(res);

printf("We got %d records.\n", rec_count);
puts("==========================");