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 <harish.sup...@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.
