\set would be very nice for variables

[hoopes]

Description

I have some psql scripts that i can invoke with a psql variable.

$ cat myscript.sql
select * from images where id = :'imgid';

$ psql
> \set imgid 123
> \i myscript.sql
...query result...

This doesn't appear supported on pgcli, unless I've missed it somehow. Is there any chance for this to be supported, or another way I could do it?

My real use-case is that the sql script has many queries, all of which are printed out. If the named queries system could execute more than one query at a time, it would be ideal, since that has an arguments system.

Your environment

• [x] Please provide your OS and version information.
  • Ubuntu 20.04.2
• [x] Please provide your CLI version.
  • 3.1.0
• [x] What is the output of pip freeze command.

$ pip freeze
cli-helpers==2.1.0
click==7.1.2
configobj==5.0.6
pendulum==2.1.2
pgcli==3.1.0
pgspecial==1.12.1
prompt-toolkit==3.0.16
psycopg2==2.8.6
Pygments==2.8.0
python-dateutil==2.8.1
pytzdata==2020.1
setproctitle==1.2.2
six==1.15.0
sqlparse==0.4.1
tabulate==0.8.7
terminaltables==3.1.0
wcwidth==0.2.5

Thanks so much, this is an awesome project!

[xpe]

I would also appreciate variable support.

BTW, the documentation page lives at: https://www.postgresql.org/docs/current/app-psql.html#APP-PSQL-VARIABLES