#!/bin/bash

PSQL_HOME='/cygdrive/c/Program Files/PostgreSQL/8.1/bin'
PSQL="$PSQL_HOME"/psql.exe
PG_DUMP="$PSQL_HOME"/pg_dump.exe
PG_RESTORE="$PSQL_HOME"/pg_restore.exe
HOSTNAME=oz.in.ia
USER=ozdev2
FROM=ozdev2
TO=dbn
PORT=5432
CNX="-h $HOSTNAME -U $USER"

"$PG_DUMP" $CNX -F c -b -v -f ozdev2.backup $FROM 1>log 2>&1
echo 'pause'
read

ALL_TABLES=`"$PSQL" $CNX -d $TO -f list_all_tables.sql`
for TABLE in $ALL_TABLES
do
	echo $TABLE
done