PostgreSQL

./configure
make
su

make install

***

/*----------------------------------------------------------------

* *connection.c *Connecting PostgreSQL Server using libpq * *IDENTIFICATION *connection.c * *---------------------------------------------------------------- */ #include <stdio.h> #include <sys/types.h> #include <stdlib.h> #include <limits.h> #include <libpq-fe.h> #include <libpq/libpq-fs.h> char conninfo[] = "hostaddr = '127.0.0.1' port = '5432' dbname = 'testdb'"; char *keyword[] = {"hostaddr","port","dbname"}; char *value[] = {"127.0.0.1","5432","testdb"}; int main(int argc,char **argv) { PGconn *conn; /* Connection Object */ /* Connect database using PQsetdb */ conn = PQsetdb(NULL,NULL,"testdb"); if (PQstatus(conn) == CONNECTION_BAD) { fprintf(stderr,"connection to database failed using PQsetdb"); fprintf(stderr,"%s",PQerrorMessage(conn)); return -1; } fprintf(stdout,"Connection to database established using PQsetdbn"); PQfinish(conn); /* Connect database using PQconnectdb */ conn = PQconnectdb(conninfo); if (PQstatus(conn) == CONNECTION_BAD) { fprintf(stderr,"connection to database failed using PQconnectdbn"); fprintf(stderr,"Connection to database established using PQconnectdbn"); PQfinish(conn); /* Connect database using PQconnectdbParams */ conn = PQconnectdbParams((const char **)keyword,(const char **)value,1); if (PQstatus(conn) == CONNECTION_BAD) { fprintf(stderr,"connection to database failed using PQconnectdbParamsn"); fprintf(stderr,"Connection to database established using PQconnectdbParamsn"); PQfinish(conn); /* Connect database using PQsetdbLogin */ conn = PQsetdbLogin("127.0.0.1","testdb","foo","bar"); if (PQstatus(conn) == CONNECTION_BAD) { fprintf(stderr,"connection to database failed using PQsetdbLoginn"); fprintf(stderr,"Connection to database established using PQsetdbLoginn"); PQfinish(conn); return 0; }