Re: how to echo SQL commands in the output of a script - Mailing list pgsql-novice

From Andreas Kretschmer
Subject Re: how to echo SQL commands in the output of a script
Date
Msg-id foob92-if7.ln1@kaufbach.delug.de
Whole thread Raw
List 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 by date:

Previous
From: Devrim GUNDUZ
Date:
Subject: Re: Problem with pl/perl in postgresql 8.0rc1
Next
From: Gino Lucrezi
Date:
Subject: how to echo SQL commands in the output of a script