Kevin Hunter wrote:
> 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
Whatever happened to pgbash? I see the last update was Feb 2003 but
that was for Pg v7.3.
Rod
--
>
> Kevin
>