Thread: Substitute Variable in select query
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?
Best Regards
Harish.
Harish.
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.
thanks for the reply David.
In case of Colon I need to set the variable first, my requirement is my select query should prompt for the input.
On Mon, 24 Aug 2020 at 10:15 PM, David G. Johnston <david.g.johnston@gmail.com> wrote:
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.
Best Regards
Harish.
Harish.
On Mon, Aug 24, 2020 at 7:21 AM harish supare <harish.supare@gmail.com> wrote:
thanks for the reply David.In case of Colon I need to set the variable first, my requirement is my select query should prompt for the input.
Please don't top-post.
psql does not have a feature that will prompt users during the execution of a query. It does, as documented, have a "\prompt" meta-command though.
David J.