How to get pgsql to echo commands in a command file

Поиск
Список
Период
Сортировка
От Michael Moore
Тема How to get pgsql to echo commands in a command file
Дата
Msg-id CACpWLjPKcSmLXPi8xr5_8kJZirRf9WMx0ea7SnBCZb1DbzZHeg@mail.gmail.com
обсуждение исходный текст
Ответы Re: How to get pgsql to echo commands in a command file  ("David G. Johnston" <david.g.johnston@gmail.com>)
Re: How to get pgsql to echo commands in a command file  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список 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

В списке pgsql-sql по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: Re: PostgreSQL:ALTER TABLE command hangs forever when DB partitioning is enabled.
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: How to get pgsql to echo commands in a command file