3
# Script to create a table 'email' and to fill it with data.
4
# The script accepts an optional argument :
5
# A database to connect to. (default 'testdb')
6
echo -n "Creating and filling table email in database ${1-testdb}..."
7
psql ${1-testdb} << EOF >/dev/null 2>&1
12
insert into email values (1,'Michael Van Canneyt','Michael@tfdec1.fys.kuleuven.ac.be');
13
insert into email values (2,'Florian Klaempfl','ba2395@fen.baynet.de');
14
insert into email values (3,'Carl-Eric Codere','codc01@gel.usherb.ca');
15
insert into email values (4,'Daniel Mantione','d.s.p.mantione@twi.tudelft.nl');
16
insert into email values (5,'Pierre Muller','muller@europe.u-strasbg.fr');
17
insert into email values (6,'Jonas Maebe','jmaebe@mail.dma.be');
18
insert into email values (7,'Peter Vreman','pfv@worldonline.nl');
19
insert into email values (8,'Gerry Dubois','gerry@webworks.ml.org');