Обсуждение: BUG #16480: Spool query with results.

Поиск
Список
Период
Сортировка

BUG #16480: Spool query with results.

От
PG Bug reporting form
Дата:
The following bug has been logged on the website:

Bug reference:      16480
Logged by:          Chandrasekhar Penchikala
Email address:      chandu_munnu@yahoo.com
PostgreSQL version: 10.9
Operating system:   Linux
Description:

Hi,

I am not able to spool the query with results, we need query also in the
output file. Is there any way to display query also in output file with
results, other than \qecho as we have multiple sql queries in sql file.

Regards,
Chandra.

Re: BUG #16480: Spool query with results.

От
"David G. Johnston"
Дата:
On Thu, Jun 4, 2020 at 7:41 PM PG Bug reporting form <noreply@postgresql.org> wrote:
The following bug has been logged on the website:

Bug reference:      16480
Logged by:          Chandrasekhar Penchikala
Email address:      chandu_munnu@yahoo.com
PostgreSQL version: 10.9
Operating system:   Linux
Description:       

Hi,

I am not able to spool the query with results, we need query also in the
output file. Is there any way to display query also in output file with
results, other than \qecho as we have multiple sql queries in sql file.

psql docs:

-e
--echo-queries
Copy all SQL commands sent to the server to standard output as well. This is equivalent to setting the variable ECHO to queries.

David J.