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

2010-02-18 Thread Reid Thompson
On Thu, 2010-02-18 at 09:33 -0600, Little, Douglas wrote: > psql p1gp1 <>$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

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

2010-02-18 Thread Vick Khera
On Thu, Feb 18, 2010 at 10:33 AM, Little, Douglas wrote: > psql > > orbitz=# \!testvar=1234 > > orbitz=# \!export testvar > > orbitz=# \!echo $testvar > > 1234 > > orbitz=# \q > > -bash-3.00$ echo > $testvar > > > 1234 > What shell are you using that allows a child process to alter the parent pro