Didier69

#!/bin/bashPSQL_HOME='/cygdrive/c/Program Files/PostgreSQL/8.1/bin'PSQL="$PSQL_HOME"/psql.exePG_DUMP="$PSQL_HOME"/pg_dump.exePG_RESTORE="$PSQL_HOME"/pg_restore.exeHOSTNAME=oz.in.iaUSER=ozdev2FROM=ozdev2TO=dbnPORT=5432CNX="-h $HOSTNAME -U $USER""$PG_DUMP" $CNX -F c -b -v -f ozdev2.backup $FROM 1>log 2>&1echo 'pause'readALL_TABLES=`"$PSQL" $CNX -d $TO -f list_all_tables.sql`for TABLE in $ALL_TABLESdo	echo $TABLEdone