Re: Prompt for parameter value in psql

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: Tiffany Thang <tiffanythang(at)gmail(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org >> PG-General Mailing List" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Prompt for parameter value in psql
Date: 2018-03-16 15:18:51
Message-ID: CAFj8pRAQn6PUmCFo-giScC=-ReNsng4ab857jn5Rj1msAN_fLg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi

2018-03-16 16:12 GMT+01:00 Tiffany Thang <tiffanythang(at)gmail(dot)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;
>
>
https://www.postgresql.org/docs/current/static/app-psql.html

see \prompt

Regards

Pavel

> Thanks.
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2018-03-16 15:26:53 Re: error 53200 out of memory
Previous Message Melvin Davidson 2018-03-16 15:18:44 Re: Prompt for parameter value in psql