./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 PQsetdb\n"); PQfinish(conn); /* Connect database using PQconnectdb */ conn = PQconnectdb(conninfo); if (PQstatus(conn) == CONNECTION_BAD) { fprintf(stderr,"connection to database Failed using PQconnectdb\n"); fprintf(stderr,"Connection to database established using PQconnectdb\n"); 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 PQconnectdbParams\n"); fprintf(stderr,"Connection to database established using PQconnectdbParams\n"); 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 PQsetdbLogin\n"); fprintf(stderr,"Connection to database established using PQsetdbLogin\n"); PQfinish(conn); return 0; }