Re: Substitute Variable in select query

Поиск

Список

Период

Сортировка

От	David G. Johnston
Тема	Re: Substitute Variable in select query
Дата	24 августа 2020 г. 17:43:06
Msg-id	CAKFQuwaZg3StdtQApNL5kFbsmiZ9GMjZOYnQFRDvtaz59xB3dA@mail.gmail.com обсуждение исходный текст
Ответ на	Substitute Variable in select query (harish supare <harish.supare@gmail.com>)
Список	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.

В списке pgsql-general по дате отправления:

От: Diego
Дата: 24 августа 2020 г., 17:25:41
Сообщение: Re: Getting away from Oracle APEX, recommendations for PostgreSQL?

От: iulian dragos
Дата: 24 августа 2020 г., 18:00:15
Сообщение: Re: Query plan prefers hash join when nested loop is much faster