Re: Substitute Variable in select query

2020-08-24 Thread harish supare
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.johns...@gmail.com> wrote: > On Monday, August 24, 2020, harish supare wrote: > >> Hi Team,

Re: Substitute Variable in select query

2020-08-24 Thread David G. Johnston
On Mon, Aug 24, 2020 at 7:21 AM harish supare 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 exe

Re: Substitute Variable in select query

2020-08-24 Thread David G. Johnston
On Monday, August 24, 2020, harish supare 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, fo

Substitute Variable in select query

2020-08-24 Thread harish supare
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.