Thread: [DOCS] How to prompt for a value if a variable is not set

[DOCS] How to prompt for a value if a variable is not set

From
randy@strausses.net
Date:
The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/9.2/static/app-psql.html
Description:

I want to make a small script to show the primary key for a table and put
the name into a variable.

Called from another script, the tablename is set in a variable called
tablename.  But if the variable is not set, I want the script to prompt for
it.

Is there a way to do this?
thx,
-r

--
Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs

Re: [DOCS] How to prompt for a value if a variable is not set

From
"David G. Johnston"
Date:
On Monday, September 18, 2017, <randy@strausses.net> wrote:
But if the variable is not set, I want the script to prompt for
it.

In version 10 this should be doable, we introduced \if conditionals.  You might be able to hack up something via "\!" in 9.6 and earlier (haven't tried it myself).

David J.