Hi Rich,
> On 09. Dec, 2020, at 19:10, Rich Shepard <rshepard@appl-ecosys.com> wrote:
>
> Looking at the postgres-12 doc I cannot find a command 'PROMPT' anywhere in
> it.
but 12 has it:
postgres=# \prompt 'input: ' input
input: this is test input
postgres=# select version(), :'input';
version | ?column?
------------------------------------------------------------------------------------+--------------------
PostgreSQL 12.5 on x86_64-pc-linux-gnu, compiled by gcc (SUSE Linux) 7.5.0, 64-bit | this is test input
(1 row)
postgres=# \?
...
Variables
\prompt [TEXT] NAME prompt user to set internal variable
\set [NAME [VALUE]] set internal variable, or list all if no parameters
\unset NAME unset (delete) internal variable
...
Cheers,
Paul