At 7:13am -0400 on Thu, 11 Sep 2008, Harald Fuchs wrote: > Nice trick, but when I try the following variant: > > psql -v TEST=16 -c 'select :TEST as "input"' > > I get [a syntax error] > This seems to be contrary to the psql manual page: Nope. Take a look at the -c option. Specifically "Thus you cannot mix SQL and psql meta-commands with this option." You might try shell interpretation: $ TEST=16; psql -c "select $TEST as \"input1\";" $ TEST=16; echo "select $TEST as \"input1\";" | psql Kevin
