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

Hello,

I want to get a sql select output into a psql variable.  Any ideas how I might need to do this.

My script executes a function which returns a TESTID.  I’d like to imbed the testid in the script output filenames.

I see that psql can set environment variables with the psql  \i command.

But got any idea how I can get sql output into a psql variable?

Thanks

Doug

psql

orbitz=# \!testvar=1234

orbitz=# \!export testvar

orbitz=# \!echo $testvar

1234

orbitz=# \q

-bash-3.00$ echo $testvar                                                                                                                                    

1234

But I’m unsure how I can get  the pgsql return code into a psql variable

The shell script

current

       psql p1gp1 <<QUIT >>$LOGFile  2>&1

\set ON_ERROR_STOP

select da_test.QATestBuild(false)

QUIT

I’d like to do something like this from my shell script

       psql p1gp1 <<QUIT >>$LOGFile  2>&1

\set ON_ERROR_STOP

select da_test.QATestBuild(false)  into :testid

\!testid=:testid

\!export $testid

QUIT

Echo $testid

1234

Doug Little

Sr. Data Warehouse Architect | Enterprise Data Management | Orbitz Worldwide

500 W. Madison, Suite 1000  Chicago IL 60661| Office 312.260.2588 | Fax 312.894.5164 | Cell 847-997-5741

Douglas.Little@orbitz.com

   orbitz.com | ebookers.com | hotelclub.com | cheaptickets.com | ratestogo.com | asiahotels.com