Re: Using Substitution Variables In PostgreSQL

Thanks for the information.

On Mon, Oct 16, 2017 at 3:27 PM, David G. Johnston <
david(dot)g(dot)johnston(at)gmail(dot)com> wrote:

> On Mon, Oct 16, 2017 at 7:08 AM, Osahon Oduware <osahon(dot)gis(at)gmail(dot)com>
> wrote:
>
>> Hi All,
>>
>> I wanted to find out how to use a substitution variable in an SQL
>> statement that would cause the user to be prompted for a value. Something
>> similar to the ampersand (&&) in ORACLE.
>>
>> For example, given the SQL statement below:
>> SELECT <col1>,<col2>,<col3>
>> FROM <table>
>> WHERE <col5> = 35
>>
>> I want the user to be prompted for the value in the WHERE (filter)
>> clause, e.g.
>> SELECT <col1>,<col2>,<col3>
>> FROM <table>
>> WHERE <col5> = ?
>>
>> I would be glad if someone could point me in the right direction.
>>
>
> ​That would be a client-side feature. The only client supported on this
> list is psql. psql does not have this capability. It does have the
> "\prompt" ​meta-command which will serve in this specific case.
>
> \prompt 'Enter a value for varname' varname
>
> SELECT ... WHERE <col5> = :'varname';
>
> https://www.postgresql.org/docs/10/static/app-psql.html
>
> David J.
>
>