gistfile1.sh

#!/bin/sh

PSQL="sudo -u postgres psql cxgn"

set -e
sudo echo;

#ssh db.sgn.cornell.edu  pg_dump --clean --schema-only --schema genomic --host localhost --user postgres cxgn | $PSQL

sudo echo;

clone_list="clone_type sequencing_primer library library_shortname_abbreviation clone"
for table in $clone_list; do

    ssh -C db.sgn.cornell.edu  pg_dump --data-only --inserts --schema genomic --table $table  --host localhost --user postgres cxgn | $PSQL

done