On Thu, 2010-02-18 at 09:33 -0600, Little, Douglas wrote: > psql p1gp1 <<QUIT >>$LOGFile 2>&1 > > \set ON_ERROR_STOP > > select da_test.QATestBuild(false) > > QUIT mod to your needs... $ cat dummy.sql #MYTESTID=`psql -t -c "select da_test.QATestBuild(false)" dbname` MYTS=`psql -t -c "select to_char(now(), 'YYYYMMDDHH24MISS')" test |sed 's/^ //'` #echo "[$MYTS]" fn=`basename $0` LOGFile=${fn}_${MYTS}.log psql test <<QUIT >>$LOGFile 2>&1 \set ON_ERROR_STOP select * from stores; QUIT -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general