Postgres Pro
Downloads
Home   >   mailing lists

Thread: BUG #16480: Spool query with results.

BUG #16480: Spool query with results.

From
PG Bug reporting form
Date:
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.

From
"David G. Johnston"
Date:
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.