Prerequisites

Because an ecpg application is written in C, you will need a C compiler, the GNU make utility, and the ecpg preprocessor and library on your system before you can try the examples in this chapter.

The makefile for this chapter follows:

 1 INCLUDES = -I$(shell pg_config --includedir)
 2
 3 LIBPATH  = -L $(shell pg_config --libdir)
 4
 5 CFLAGS    += $(INCLUDES) -g
 6 LDFLAGS   += -g
 7 LDLIBS    += $(LIBPATH) -lecpg -lpq
 8 ECPGFLAGS += -c $(INCLUDES)
 9 ECPG       = ecpg
10
11 .SUFFIXES: .pgc
12
13 .pgc.c:
14         $(ECPG) $(ECPGFLAGS) $?
15
16 ALL  = client1a client1b client2a client2b client2c
17 ALL += client3a client3b client3c client3d client3e client3f
18 ALL += client4.pgc
19
20 all: $(ALL)
21
22 clean:
23         rm -f $(ALL) *~
24

The examples in this chapter follow the normal PostgreSQL convention of naming ecpg source files with the extension .pgc. The makefile rules on lines 11 through 14 tell make that it can convert a .pgc file into a .c file by running the ecpg preprocessor.

Assuming that you have the prerequisites in place, let's start out by developing a simple client that will connect to a database using ecpg.