Home > mailing lists

Re: Substitute Variable in select query - Mailing list pgsql-general

From	David G. Johnston
Subject	Re: Substitute Variable in select query
Date	August 24, 2020 17:43:06
Msg-id	CAKFQuwaZg3StdtQApNL5kFbsmiZ9GMjZOYnQFRDvtaz59xB3dA@mail.gmail.com Whole thread Raw
In response to	Substitute Variable in select query (harish supare <harish.supare@gmail.com>)
List	pgsql-general

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

From: Diego
Date: 24 August 2020, 17:25:41
Subject: Re: Getting away from Oracle APEX, recommendations for PostgreSQL?

From: iulian dragos
Date: 24 August 2020, 18:00:15
Subject: Re: Query plan prefers hash join when nested loop is much faster