Re: Postgres problem

Prof. L M Patnaik napsal(a):
> 
> Hello:
> 
> I am having problem interfacing the postgres database with the 
> frontend(libpq),i.e using C.Database runs fine.
> 
>  PROBLEMS ARE:
>             1)When compiling the C-program given in the 
>              example for connecting the database to the
>              frontend using
>        $gcc -I /home/guest/pgsql/include test.c

Try something like this       $gcc -I /home/guest/pgsql/include -L /home/guest/pgsql/lib -lpq test.c

I think that postgres libraries are stored in /home/guest/pgsql/lib.

> ...............................................................
>             
>             2)When I want to use the command
>               $createlang c (dbname)
>             OUTPUT:
>                    createlang:missing required argument PGLIB directory.            

You don't have specified the path to PGLIB. createlang can't find them.
Try set environment variable PGLIB (e.g. in bash:
export PGLIB=/home/guest/pgsql/lib). Or append this path to environment
variable LD_LIBRARY_PATH.

Regards

Luf