Re: Command Line option misunderstanding

On 12/2/24 13:47, punch-hassle-guise(at)duck(dot)com wrote:
> It would appear that I have a fundamental misunderstanding
> of either the english language or the psql man page.

<snip>

> My attempts at implementing my understanding of man page
> and attempts at implementing what I perceive to be someones mis-writing
> of man page
>
>
> ----attempt 1--
> psql -h anna -d GT7 -v v1=12 -c 'select :v1'

I forget the details, but I think it has to do with the way "-c"
commands are processed. Try this:

echo 'select :v1' | psql -d test -v v1=42
?column?
----------
42
(1 row)

--
Joe Conway
PostgreSQL Contributors Team
RDS Open Source Databases
Amazon Web Services: https://aws.amazon.com