Re: Prompt for parameter value in psql

[Pavel Stehule <pavel.stehule@xxxxxxxxx>]

Hi

2018-03-16 16:12 GMT+01:00 Tiffany Thang <tiffanythang@xxxxxxxxx>:

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;

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

see \prompt

Regards

Pavel
 

Thanks.