Jim Parker wrote:
>
>Should I create a library to hold the ECPG routines ?
>
It is not necessary.
>
>Does anyone have any example code/Makefile I can look at ?
>
This is an example similar to the makefile that I use:
EC = ecpg
CC = gcc
INCPG = /usr/local/pgsql/include # Path for postgresql includes.
INCAPP = ../h # Path for application-specific
header.
INCSQL = ../h # Path for host variables
declarations header.
LIBPG = /usr/local/pgsql/lib # Path for ecpg libraries.
LIBSPG = -lecpg -lpq # Ecpg libraries.
CFLAGS = -Wall -g -c
# I use the suffix '.ec' for ecpg source files instead of '.pgc'.
%.c : %.ec $(EC) -t -I $(INCSQL) -o $@ $<
%.o : %.c $(CC) $(CFLAGS) -I $(INCPG) -I $(INCAPP) -o $@ $<
% : %.o ;
.PHONY: all util clean
all: util program1 program2
util: util1.o util2.o util3.o
program1: program1.o util1.o util2.o $(CC) -o $@ $^ -L $(LIBPG) $(LIBSPG)
program2: program2.o util2.o util3.o $(CC) -o $@ $^ -L $(LIBPG) $(LIBSPG)
clean: -rm -f *.o core
Regards,
Antonio Sergio