Postgres Pro
Downloads
Home   >   mailing lists

Re: Prompt for parameter value in psql - Mailing list pgsql-general

From Melvin Davidson
Subject Re: Prompt for parameter value in psql
Date
Msg-id CANu8FizB-1cYE__SRj3+2oHMGVQBpEZ23KHogz4Yk1Eb5RgzHg@mail.gmail.com
Whole thread Raw
In response to Prompt for parameter value in psql  (Tiffany Thang <tiffanythang@gmail.com>)
List pgsql-general
Tree view


On Fri, Mar 16, 2018 at 11:12 AM, Tiffany Thang <tiffanythang@gmail.com> wrote:
Hi,
Would it be possible to prompt for a user input in psql like in Oracle sqlplus?

In oracle, we use the & sign, for example,
select * from emp where empid=&empidvalue;

Thanks.


https://www.postgresql.org/docs/9.6/static/app-psql.html

\prompt [ text ] name

Prompts the user to supply text, which is assigned to the variable name. An optional prompt string, text, can be specified. (For multiword prompts, surround the text with single quotes.)

By default, \prompt uses the terminal for input and output. However, if the -f command line switch was used, \prompt uses standard input and standard output.
--

Melvin Davidson
Maj. Database & Exploration Specialist
Universe Exploration Command – UXC
Employment by invitation only!

pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: SELECT .. FOR UPDATE: find out who locked a row
Next
From: Pavel Stehule
Date:
Subject: Re: Prompt for parameter value in psql