Re: How to get pgsql to echo commands in a command file - Mailing list pgsql-sql

From Adrian Klaver
Subject Re: How to get pgsql to echo commands in a command file
Date
Msg-id 4b482dc1-d2ac-e61a-5401-74820591fb09@aklaver.com
Whole thread Raw
In response to How to get pgsql to echo commands in a command file  (Michael Moore <michaeljmoore@gmail.com>)
Responses Re: How to get pgsql to echo commands in a command file
List pgsql-sql
On 04/22/2016 03:50 PM, Michael Moore wrote:
> I log into pgsql and then type:
> \i test.sql
>
> test.sql contains a single SELECT command and when I run that file I see
> the result of the select command.. The problem is, I also want to see
> the SELECT command itself.
>
> I've tried
> /echo
> /qecho
> and a lot of other commands, but nothing works.

http://www.postgresql.org/docs/9.5/interactive/app-psql.html
"
ECHO
    If set to all, all nonempty input lines are printed to standard 
output as they are read. (This does not apply to lines read 
interactively.) To select this behavior on program start-up, use the 
switch -a. If set to queries, psql prints each query to standard output 
as it is sent to the server. The switch for this is -e. If set to 
errors, then only failed queries are displayed on standard error output. 
The switch for this is -b. If unset, or if set to none (or any other 
value than those above) then no queries are displayed.
"


aklaver@panda:~> cat psql_test.sql
select * from a ;

aklaver@panda:~> psql -a -d test -U  postgres -h localhost
psql (9.4.6)
SSL connection (protocol: TLSv1.2, cipher: ECDHE-RSA-AES256-GCM-SHA384, 
bits: 256, compression: off)
Type "help" for help.

test=# \i psql_test.sql
select * from a ; id | v1 | v2 | v3
----+----+----+----  1 |  2 |  3 |  4  2 |  2 |  3 |  4
(2 rows)



>
> What do I need to do in order to see the commands in test.sql as well as
> the output of those commands on my pgsql window?
>
> I'm running on Windows 7 if that matters.
>
> TIA,
> Mike


-- 
Adrian Klaver
adrian.klaver@aklaver.com



pgsql-sql by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: How to get pgsql to echo commands in a command file
Next
From: Michael Moore
Date:
Subject: Re: How to get pgsql to echo commands in a command file