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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
