#this bash script executes SQL code from .sql files

DATABASE_NAME="nobody"
SQL_PATH="/usr/local/pgsql/bin"
SQL_FILES=$(ls *_$1.sql *_$1.noauto)
#ls *_$1.* | sort

rm sql_messages.log sql_errors.log
for filename in $SQL_FILES ; do
echo "executing SQL for" $filename | tee -a sql_messages.log sql_errors.log
./sql_run.pl "dbname=$DATABASE_NAME" $filename >>sql_messages.log 2>>sql_errors.log
done