Postgres Pro
Downloads
Home   >   mailing lists

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

From Peter Eisentraut
Subject Re: psql command line variables are unknown when -c SQL statement are executed
Date
Msg-id 1258370638.23638.1.camel@fsopti579.F-Secure.com
Whole thread Raw
In response to psql command line variables are unknown when -c SQL statement are executed  (Pavel Stehule <pavel.stehule@gmail.com>)
Responses Re: psql command line variables are unknown when -c SQL statement are executed
List pgsql-bugs
Tree view 
On mån, 2009-11-16 at 10:19 +0100, Pavel Stehule wrote:
> wrong:
>
> pavel@nemesis ~]$ psql postgres -v x=10 -c "select :x"
> ERROR:  syntax error at or near ":"
> LINE 1: select :x
>                ^

This is documented in the psql man page.

pgsql-bugs by date:

Previous
From: Pavel Stehule
Date:
Subject: psql command line variables are unknown when -c SQL statement are executed
Next
From: Pavel Stehule
Date:
Subject: Re: psql command line variables are unknown when -c SQL statement are executed