#include #include int main(){ PGresult *result; PGconn *conn; const char *connection_str = "host=localhost port=5432 dbname=*** user=*** password=***"; conn = PQconnectdb(connection_str); if (PQstatus(conn) == CONNECTION_BAD) { fprintf(stderr, "Connection to %s failed, %s", connection_str, PQerrorMessage(conn)); } else { result = PQexec(conn, "SELECT id as Nr, fname as Imie, lname as Nazwisko FROM lab10.person;"); { PQprintOpt pqp; pqp.header = 1; pqp.align = 1; pqp.html3 = 1; pqp.expanded = 0; pqp.pager = 0; pqp.fieldSep = ""; pqp.tableOpt = "align=center"; pqp.caption = "Tabela person"; pqp.fieldName = NULL; printf("\n"); PQprint(stdout, result, &pqp); printf("\n"); } } PQfinish(conn); return EXIT_SUCCESS; }