Re: psql command line variables are unknown when -c SQL statement are executed - Mailing list pgsql-bugs

2009/11/16 Peter Eisentraut <peter_e@gmx.net>:
> On m=C3=A5n, 2009-11-16 at 10:19 +0100, Pavel Stehule wrote:
>> wrong:
>>
>> pavel@nemesis ~]$ psql postgres -v x=3D10 -c "select :x"
>> ERROR: =C2=A0syntax error at or near ":"
>> LINE 1: select :x
>> =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0^
>
> This is documented in the psql man page.

I don't see it, Peter?

Is it some reason for it? I don't understand, why this order is correct:

execute statement
process external variables
finish

Pavel

>
>
>