Hello,
a quick question about
https://www.postgresql.org/docs/current/app-psql.html
and the \set option
it seems that \set does not interpret an 'enter' interactively the same
as an 'enter' in a short script made with \e
###
* case 1:
postgres=# \set x 1
postgres=# select :x;
?column?
----------
1
###
###
* case 2:
postgres=# \e
-- enter the following the editor (the same code as above)
\set x 1
select :x;
-- save and quit
postgres=#
-- no output
-- curiosly: again \e
postgres=#\e
-- shows select 1; in the editor in v14
-- shows nothing in the editor in v13 (or recursive the content being
cut off)
###
###
variation of case 2:
postgres=# \e
-- enter the following the editor (the same code as above)
\set x 1
select :x;
-- save and quit
postgres=# select :x;
select1select1
----------------
1
###
Doing the same thing with \i instead of \e does behave like i would
expect, ie the same as case 1.
This is referred to as meta-commands in de manual which are to be
affected when using \e, but \g instead of ; seems to work (while it
should be the same?)
###
variation of case 2 using \g instead of ; :
postgres=# \e
-- enter the following the editor (the same code as above)
\set x 1
select :x \g
-- save and quit
?column?
----------
1
(1 row)
postgres=#
###
--
mvg,
Wim