Re: [GENERAL] SQL select return into PSQL variables.

[Reid Thompson]

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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general