Re: Prompt for parameter value in psql

2018-03-16 Thread 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=&empidvalue; > > https://www.postgresql.org/docs/current/static/app-psql.html see

Re: Prompt for parameter value in psql

2018-03-16 Thread 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=&empidvalue; > > Thanks. > *https://www.postgresql.org/docs/9.6/stat

Prompt for parameter value in psql

2018-03-16 Thread 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=&empidvalue; Thanks.