Re: Using Substitution Variables In PostgreSQL

On 16/10/2017 17:08, Osahon Oduware 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.

Just write a bash script that asks for values and then use the -v feature of psql .

--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt