How to get pgsql to echo commands in a command file

From: Michael Moore <michaeljmoore(at)gmail(dot)com>
To: postgres list <pgsql-sql(at)postgresql(dot)org>
Subject: How to get pgsql to echo commands in a command file
Date: 2016-04-22 22:50:14
Message-ID: CACpWLjPKcSmLXPi8xr5_8kJZirRf9WMx0ea7SnBCZb1DbzZHeg@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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.

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message David G. Johnston 2016-04-22 22:58:31 Re: How to get pgsql to echo commands in a command file
Previous Message Adrian Klaver 2016-04-21 14:16:58 Re: Re: PostgreSQL:ALTER TABLE command hangs forever when DB partitioning is enabled.