> I have been trying to run a sample code for postgreSQL
> database. I just want to create a database and do simple
> insertion and extraction of the inserted data. I have
> created .pgc file and am able to generate .c file using
> ecpg but I am stuck with gcc , not able to create the
> binary from .c file.
Use a Makefile to specify the locations of the libraries,
such as...
-----snip-----
SRCDIR=../postgres/src
CFLAGS+=-I$(SRCDIR)/include
CFLAGS+=-I$(SRCDIR)/interfaces/libpq
CFLAGS+=-I$(SRCDIR)/interfaces/ecpg/include
LIBPQDIR=$(SRCDIR)/interfaces/libpq
LIBECPGDIR=$(SRCDIR)/interfaces/ecpg/lib
LDFLAGS+=-L$(LIBPQDIR) -lpq
LDFLAGS+=-L$(LIBECPGDIR) -lecpg
LDFLAGS+=-g
%.c : %.pgc
ecpg -t -o $@ $<
-----snip-----
/andy
---
Andy Riebs, andy.riebs@compaq.com Alpha Technology Solutions Group
978-506-6628, fax 978-506-6524 Compaq Computer Corporation
(h) andy@freckles.mv.com <http://www.linuxalpha.compaq.com>