On Mon, Aug 24, 2020 at 7:21 AM harish supare <harish.sup...@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.