Re: SQL select return into PSQL variables. - Mailing list pgsql-general

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