Add pgsql sandbox

1 files changed, 28 insertions, 0 deletions

diff --git a/sandbox/pgsql/pgsql.c b/sandbox/pgsql/pgsql.c
new file mode 100644
index 0000000..ffbae9f
--- /dev/null
+++ b/sandbox/pgsql/pgsql.c
@@ -0,0 +1,28 @@
+#include <stdio.h>
+
+#include <libpq-fe.h>
+#include <pg_config.h>
+
+int main() {
+	PGconn* conn;
+	PGresult* result;
+
+	conn = PQconnectdb("host=localhost port=5432 dbname=clog password=p0stgres user=postgres");
+
+	if(PQstatus(conn) != CONNECTION_OK) {
+		printf("Connection to database failed:%s\n", PQerrorMessage(conn));
+	}
+
+	result = PQexec(conn, "SELECT * FROM ENTRIES");
+
+	PQprintOpt options = {0};
+	options.header = 1;    /* Ask for column headers */
+	options.align = 1;    /* Pad short columns for alignment */
+	options.fieldSep = "|";  /* Use a pipe as the field separator */
+
+	PQprint(stdout, result, &options);
+
+	PQclear(result);
+	PQfinish(conn);
+}
+