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

From Pavel Stehule
Subject Re: Prompt for parameter value in psql
Date
Msg-id CAFj8pRAQn6PUmCFo-giScC=-ReNsng4ab857jn5Rj1msAN_fLg@mail.gmail.com
Whole thread Raw
In response to Prompt for parameter value in psql  (Tiffany Thang <tiffanythang@gmail.com>)
List pgsql-general
Hi

2018-03-16 16:12 GMT+01:00 Tiffany Thang <tiffanythang@gmail.com>:
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;

see \prompt

Regards

Pavel
 
Thanks.

pgsql-general by date:

Previous
From: Melvin Davidson
Date:
Subject: Re: Prompt for parameter value in psql
Next
From: Adrian Klaver
Date:
Subject: Re: error 53200 out of memory