diff --git a/database.c b/database.c new file mode 100644 --- /dev/null +++ b/database.c @@ -0,0 +1,59 @@ +/** + * $Id: main.c,v 1.1.1.1 2008-04-28 17:32:52 mbroeker Exp $ + * $Source: /development/c/database/main.c,v $ + * + */ + +#include +#include +#include + +int main (int argc, char **argv) +{ + char *conninfo; + PGconn *conn; + PGresult *res; + int nFields; + int i; + int j; + + conninfo = "dbname=lightintron"; + + conn = PQconnectdb (conninfo); + if (conn == NULL) + printf ("ERROR\n"); + else + printf ("SUCCESS\n"); + + if (argc != 2) + res = PQexec (conn, "select \"MNr\", \"Name\", \"Vorname\", \"Bemerkungen\" from \"Mitarbeiter\""); + else + res = PQexec (conn, argv[1]); + + /* + * first, print out the attribute names + */ + nFields = PQnfields (res); + for (i = 0; i < nFields; i++) + printf ("%-15s", PQfname (res, i)); + printf ("\n\n"); + + /* + * next, print out the rows + */ + + for (i = 0; i < PQntuples (res); i++) { + for (j = 0; j < nFields; j++) { + if (!strcmp (PQfname (res, j), "message")) + printf ("\n"); + printf ("%-15s", PQgetvalue (res, i, j)); + } + printf ("\n"); + } + + PQclear (res); + + PQfinish (conn); + + return 0; +}