From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
---|---|
To: | chandu_munnu(at)yahoo(dot)com, PostgreSQL mailing lists <pgsql-bugs(at)lists(dot)postgresql(dot)org> |
Subject: | Re: BUG #16480: Spool query with results. |
Date: | 2020-06-05 05:07:13 |
Message-ID: | CAKFQuwaVysbupdH0-X9bMXeZjNq2322_UbiRt_LBg23gGmGqDw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
On Thu, Jun 4, 2020 at 7:41 PM PG Bug reporting form <noreply(at)postgresql(dot)org>
wrote:
> The following bug has been logged on the website:
>
> Bug reference: 16480
> Logged by: Chandrasekhar Penchikala
> Email address: chandu_munnu(at)yahoo(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | Christoph Berg | 2020-06-05 10:27:43 | Re: time values past 24:00:00 (or rather 23:59:60) |
Previous Message | Fabien COELHO | 2020-06-05 04:44:33 | Re: pgbench bug / limitation |