Shell脚本回顾练习-操作Postgresql数据库。

#!/bin/bash
filename="/tmp/pgtest.txt"
host=127.0.0.1
user=postgres
password=postgres
port=5432
dbname=postgres

gettable(){
if [ ! -e ${filename} -o ! -s ${filename} ];
  then
    `touch /tmp/pgtest.txt`
  #psql -h 127.0.0.1 -U postgres -p postgres > $filename << EOF 
  psql "host=$host port=$port user=$user  password=$password" << EOF
     select tablename from pg_tables where tablename like 'pg%';
     \q
EOF
fi
}


selecttable(){
count=1;
count_row=`awk '{print NR}' $filename|tail -n1`;
for table in `awk -F, '{print $1}' $filename`
  do
     if (( 2 <  $count && $count < ${count_row}-1 ))
        then
          #echo $table;
          psql "host=$host  user=$user  password=$password " <<EOF
          select * from $table limit 1;
          \q
EOF

     fi
     let "count++";
done

}
#psql -h 127.0.0.1 -U postgres -W postgres > /tmp/pgtest.txt << EOF
#   select tablename from pg_tables where tablename like 'pg%';
gettable;
selecttable;