如何在Shell脚本中保存Postgres SQL的结果
#!/bin/sh
DB=$1
USER=$2
PASS=$3
PGPASSWORD=$PASS psql \
-X \
-h $HOST \
-U $USER \
-p $PORT \
-c "select class_name from class_definition " \
--single-transaction \
--no-align \
-t \
--field-separator ' ' \
--quiet \
-d $DB | while read class_name; do
echo $class_name
done
对于Oracle也是一样的
#!/bin/sh
DB=$1
USER=$2
PASS=$3
class_name =`sqlplus -s $USER/$PASS@$DB <<EOF
set pages 0 echo off feed off;
select class_name from class_definition;
exit;
EOF`
echo "$class_name" |while read cn ; do
echo $cn
done;