How to store Postgre SQL result in bash variable

如何在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;