Re: how to echo SQL commands in the output of a script

Поиск
Список
Период
Сортировка
От Andreas Kretschmer
Тема Re: how to echo SQL commands in the output of a script
Дата
Msg-id foob92-if7.ln1@kaufbach.delug.de
обсуждение исходный текст
Список pgsql-novice
begin  Gino Lucrezi <gino-pgadmin@lucrezi.net> wrote:
> I have a number of sql scripts which I execute using psql -f

> I can easily redirect the output for logging and archival.
> However, psql will only display the result of each SQL statement, and
> not the actual SQL statement.
> While this is fine for most purposes, sometimes I'd rather have both
> the SQL statement and its output on the same file.

> Is there a way to have it?

I think, you search the '-e' - Option for psql.



> In case I wasn't clear... did you ever do any batch programming under
> MS-DOS? I need the equivalent of the ECHO ON command

What for the hell is MS-DOS?



> Thanks in advance

Please ;-)



end
Andreas
--
Diese Message wurde erstellt mit freundlicher Unterstützung eines freilau-
fenden Pinguins aus artgerechter Freilandhaltung.   Er ist garantiert frei
von Micro$oft'schen Viren. (#97922 http://counter.li.org)     GPG 7F4584DA
Was, Sie wissen nicht, wo Kaufbach ist? Hier: N 51.05082°, E 13.56889° ;-)

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

Предыдущее
От: Devrim GUNDUZ
Дата:
Сообщение: Re: Problem with pl/perl in postgresql 8.0rc1
Следующее
От: Gino Lucrezi
Дата:
Сообщение: how to echo SQL commands in the output of a script