pg.ddx.io pgsql-bugs@postgresql.org mailing list archive
help / color / mirror / Atom feedBUG #18061: The psql -v variable option does not work for the -c command option
3+ messages / 3 participants
[nested] [flat]
* BUG #18061: The psql -v variable option does not work for the -c command option
@ 2023-08-18 14:28 PG Bug reporting form <noreply@postgresql.org>
2023-08-20 16:58 ` Re: BUG #18061: The psql -v variable option does not work for the -c command option David G. Johnston <david.g.johnston@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: PG Bug reporting form @ 2023-08-18 14:28 UTC (permalink / raw)
To: pgsql-bugs@lists.postgresql.org; +Cc: robertmccollistergreene@hotmail.com
The following bug has been logged on the website:
Bug reference: 18061
Logged by: Robert Greene
Email address: robertmccollistergreene@hotmail.com
PostgreSQL version: 15.4
Operating system: Windows, Linux
Description:
psql -v v1=1 -c "select col from table where colname=:v1;"
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: BUG #18061: The psql -v variable option does not work for the -c command option
2023-08-18 14:28 BUG #18061: The psql -v variable option does not work for the -c command option PG Bug reporting form <noreply@postgresql.org>
@ 2023-08-20 16:58 ` David G. Johnston <david.g.johnston@gmail.com>
2023-08-22 15:31 ` Re: BUG #18061: The psql -v variable option does not work for the -c command option Robert Greene <RobertMcCollisterGreene@hotmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: David G. Johnston @ 2023-08-20 16:58 UTC (permalink / raw)
To: robertmccollistergreene@hotmail.com; pgsql-bugs@lists.postgresql.org
On Sun, Aug 20, 2023 at 8:56 AM PG Bug reporting form <
noreply@postgresql.org> wrote:
> The following bug has been logged on the website:
>
> Bug reference: 18061
> Logged by: Robert Greene
> Email address: robertmccollistergreene@hotmail.com
> PostgreSQL version: 15.4
> Operating system: Windows, Linux
> Description:
>
> psql -v v1=1 -c "select col from table where colname=:v1;"
>
Yes, since psql variables are not parsable by the server the following
sentence in the documentation for -c explains your observation:
> command must be either a command string that is completely parsable by
the server (i.e., it contains no psql-specific features), or a single
backslash command.
David J.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: BUG #18061: The psql -v variable option does not work for the -c command option
2023-08-18 14:28 BUG #18061: The psql -v variable option does not work for the -c command option PG Bug reporting form <noreply@postgresql.org>
2023-08-20 16:58 ` Re: BUG #18061: The psql -v variable option does not work for the -c command option David G. Johnston <david.g.johnston@gmail.com>
@ 2023-08-22 15:31 ` Robert Greene <RobertMcCollisterGreene@hotmail.com>
0 siblings, 0 replies; 3+ messages in thread
From: Robert Greene @ 2023-08-22 15:31 UTC (permalink / raw)
To: David G. Johnston <david.g.johnston@gmail.com>; pgsql-bugs@lists.postgresql.org <pgsql-bugs@lists.postgresql.org>
Rats
Sent from my Verizon, Samsung Galaxy smartphone
Get Outlook for Android<https://aka.ms/AAb9ysg;
________________________________
From: David G. Johnston <david.g.johnston@gmail.com>
Sent: Sunday, August 20, 2023 11:58:01 AM
To: robertmccollistergreene@hotmail.com <robertmccollistergreene@hotmail.com>; pgsql-bugs@lists.postgresql.org <pgsql-bugs@lists.postgresql.org>
Subject: Re: BUG #18061: The psql -v variable option does not work for the -c command option
On Sun, Aug 20, 2023 at 8:56 AM PG Bug reporting form <noreply@postgresql.org<mailto:noreply@postgresql.org>> wrote:
The following bug has been logged on the website:
Bug reference: 18061
Logged by: Robert Greene
Email address: robertmccollistergreene@hotmail.com<mailto:robertmccollistergreene@hotmail.com>
PostgreSQL version: 15.4
Operating system: Windows, Linux
Description:
psql -v v1=1 -c "select col from table where colname=:v1;"
Yes, since psql variables are not parsable by the server the following sentence in the documentation for -c explains your observation:
> command must be either a command string that is completely parsable by the server (i.e., it contains no psql-specific features), or a single backslash command.
David J.
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2023-08-22 15:31 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2023-08-18 14:28 BUG #18061: The psql -v variable option does not work for the -c command option PG Bug reporting form <noreply@postgresql.org>
2023-08-20 16:58 ` David G. Johnston <david.g.johnston@gmail.com>
2023-08-22 15:31 ` Robert Greene <RobertMcCollisterGreene@hotmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox