From 40441e01b6e73a0a1d7f06377b3607f151aed65b Mon Sep 17 00:00:00 2001
From: Michael McVady <femtonaut@gmail.com>
Date: Thu, 23 Sep 2021 00:22:10 -0500
Subject: Add pgsql sandbox

---
 sandbox/pgsql/Makefile |  5 +++++
 sandbox/pgsql/build    |  3 +++
 sandbox/pgsql/pgsql.c  | 28 ++++++++++++++++++++++++++++
 3 files changed, 36 insertions(+)
 create mode 100644 sandbox/pgsql/Makefile
 create mode 100644 sandbox/pgsql/build
 create mode 100644 sandbox/pgsql/pgsql.c

(limited to 'sandbox/pgsql')

diff --git a/sandbox/pgsql/Makefile b/sandbox/pgsql/Makefile
new file mode 100644
index 0000000..1037bc4
--- /dev/null
+++ b/sandbox/pgsql/Makefile
@@ -0,0 +1,5 @@
+build:
+	gcc pgsql.c -I/usr/include/postgresql -lpq -o pgsql
+
+clean:
+	rm pgsql
diff --git a/sandbox/pgsql/build b/sandbox/pgsql/build
new file mode 100644
index 0000000..f5e320e
--- /dev/null
+++ b/sandbox/pgsql/build
@@ -0,0 +1,3 @@
+gcc -c -I/usr/include/postgresql pgsql.c -L/usr/include/pgsql -lpq -o pgsql
+pg_config --libdir
+pg_config --includedir
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);
+}
+
-- 
cgit v1.2.3