Home > mailing lists

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

From	Tiffany Thang
Subject	Prompt for parameter value in psql
Date	March 16, 2018 21:12:21
Msg-id	CAB_W-NO0y6smn-uCH876JLGiLukrY5zijp+bY5Gc28BekNb9Pg@mail.gmail.com Whole thread Raw
Responses	Re: Prompt for parameter value in psql (Melvin Davidson <melvin6925@gmail.com>) Re: Prompt for parameter value in psql (Pavel Stehule <pavel.stehule@gmail.com>)
List	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.

From: "Enrico Thierbach"
Date: 16 March 2018, 21:08:12
Subject: Re: SELECT .. FOR UPDATE: find out who locked a row

From: "David G. Johnston"
Date: 16 March 2018, 21:17:50
Subject: Re: SELECT .. FOR UPDATE: find out who locked a row