On Mon, Aug 24, 2020 at 7:21 AM harish supare <harish(dot)supare(at)gmail(dot)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.