Postgres Pro
Downloads
Home   >   mailing lists

Re: Substitute Variable in select query - Mailing list pgsql-general

From David G. Johnston
Subject Re: Substitute Variable in select query
Date
Msg-id CAKFQuwYLa8hnr5CuAdux0C_MRWiNTEdUPfwBUAJT9SzSqBjYrA@mail.gmail.com
Whole thread Raw
In response to Substitute Variable in select query  (harish supare <harish.supare@gmail.com>)
Responses Re: Substitute Variable in select query  (harish supare <harish.supare@gmail.com>)
List pgsql-general
Tree view
On Monday, August 24, 2020, harish supare <harish.supare@gmail.com> wrote:
Hi Team,

Would like to know what the substitute/input variable available in psql.


Oracle we use &  - select a, b , c from table where a like &a;

Is there an alternative in psql?


Colon - read the documentation, psql section, for the exact syntax.

David J.

pgsql-general by date:

Previous
From: Susan Joseph
Date:
Subject: SSL between Primary and Seconday PostgreSQL DBs
Next
From: harish supare
Date:
Subject: Re: Substitute Variable in select query