fpc/packages/postgres/scripts/mkdb

#!/bin/sh
#
# Script to create a table 'email' and to fill it with data.
# The script accepts an optional argument : 
# A database to connect to. (default 'testdb')
echo -n "Creating and filling table email in database ${1-testdb}..."
psql ${1-testdb} << EOF >/dev/null 2>&1
create table email ( 
id int4,
name text,
email text);
insert into email values (1,'Michael Van Canneyt','[email protected]');
insert into email values (2,'Florian Klaempfl','[email protected]');
insert into email values (3,'Carl-Eric Codere','[email protected]');
insert into email values (4,'Daniel Mantione','[email protected]');
insert into email values (5,'Pierre Muller','[email protected]');
insert into email values (6,'Jonas Maebe','[email protected]');
insert into email values (7,'Peter Vreman','[email protected]');
insert into email values (8,'Gerry Dubois','[email protected]');
EOF
if [ ! $? = 0 ]; then
  echo "Failed."
else
  echo "Done."
fi
# Ready