diff options
Diffstat (limited to 'sandbox/pgsql')
| -rw-r--r-- | sandbox/pgsql/Makefile | 5 | ||||
| -rw-r--r-- | sandbox/pgsql/build | 3 | ||||
| -rw-r--r-- | sandbox/pgsql/pgsql.c | 28 |
3 files changed, 36 insertions, 0 deletions
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); +} + |