c
#include <stdio.h>
#include <stdlib.h>
#include <pgembed.h>
int main() {
PGconn* conn;
PGresult* res;
conn = PQconnectdb("dbname=mydb");
if (PQstatus(conn) != CONNECTION_OK) {
fprintf(stderr, "Connection to database failed: %s", PQerrorMessage(conn));
PQfinish(conn);
exit(1);
}
res = PQexec(conn, "SELECT * FROM users");
if (PQresultStatus(res) != PGRES_TUPLES_OK) {
fprintf(stderr, "Query execution failed: %s", PQerrorMessage(conn));
PQclear(res);
PQfinish(conn);
exit(1);
}
int numRows = PQntuples(res);
for (int i = 0; i < numRows; i++) {
printf("User ID: %s
", PQgetvalue(res, i, 0));
printf("Username: %s
", PQgetvalue(res, i, 1));
}
PQclear(res);
PQfinish(conn);
return 0;
}
