On 12/2/24 13:47, punch-hassle-guise@duck.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