Re: Substitute Variable in select query

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: >

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.