Re: BUG #16480: Spool query with results. - Mailing list pgsql-bugs

From David G. Johnston
Subject Re: BUG #16480: Spool query with results.
Date
Msg-id CAKFQuwaVysbupdH0-X9bMXeZjNq2322_UbiRt_LBg23gGmGqDw@mail.gmail.com
Whole thread Raw
In response to BUG #16480: Spool query with results.  (PG Bug reporting form <noreply@postgresql.org>)
List pgsql-bugs
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.

pgsql-bugs by date:

Previous
From: Fabien COELHO
Date:
Subject: Re: pgbench bug / limitation
Next
From: Christoph Berg
Date:
Subject: Re: time values past 24:00:00 (or rather 23:59:60)