批量导出greenplum表结构

批量导出greenplum表结构

#!/bin/bash

export PGPASSWORD=123

for i in `cat table_list.txt`
do
echo "now begin backup $1"
psql -d bigdata -h 10.0.0.11 -p 5432 -U dba -c "\copy (select * from app01.$i) to /data/backup/app01.$i.csv with csv"
echo "$i backup sucessfull"
done