Re: Prompt for parameter value in psql

[Pavel Stehule]

Hi

2018-03-16 16:12 GMT+01:00 Tiffany Thang :

> 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=
>
>
https://www.postgresql.org/docs/current/static/app-psql.html

see \prompt

Regards

Pavel


> Thanks.
>

Re: Prompt for parameter value in psql

[Melvin Davidson]

On Fri, Mar 16, 2018 at 11:12 AM, Tiffany Thang 
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=
>
> 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!

Prompt for parameter value in psql

[Tiffany Thang]

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=

Thanks.