Prompt for parameter value in psql

From: Tiffany Thang <tiffanythang(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Prompt for parameter value in psql
Date: 2018-03-16 15:12:21
Message-ID: CAB_W-NO0y6smn-uCH876JLGiLukrY5zijp+bY5Gc28BekNb9Pg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David G. Johnston 2018-03-16 15:17:50 Re: SELECT .. FOR UPDATE: find out who locked a row
Previous Message Enrico Thierbach 2018-03-16 15:08:12 Re: SELECT .. FOR UPDATE: find out who locked a row