pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
BUG #16480: Spool query with results.
2+ messages / 2 participants
[nested] [flat]

* BUG #16480: Spool query with results.
@ 2020-06-05 02:29  PG Bug reporting form <noreply@postgresql.org>
  0 siblings, 1 reply; 2+ messages in thread

From: PG Bug reporting form @ 2020-06-05 02:29 UTC (permalink / raw)
  To: pgsql-bugs@lists.postgresql.org; +Cc: chandu_munnu@yahoo.com

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.



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: BUG #16480: Spool query with results.
@ 2020-06-05 05:07  David G. Johnston <david.g.johnston@gmail.com>
  parent: PG Bug reporting form <noreply@postgresql.org>
  0 siblings, 0 replies; 2+ messages in thread

From: David G. Johnston @ 2020-06-05 05:07 UTC (permalink / raw)
  To: chandu_munnu@yahoo.com, PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>

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.

^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2020-06-05 05:07 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2020-06-05 02:29 BUG #16480: Spool query with results. PG Bug reporting form <noreply@postgresql.org>
2020-06-05 05:07 ` David G. Johnston <david.g.johnston@gmail.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox