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

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

From
Andreas Kretschmer
Date:
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° ;-)

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

From
Gino Lucrezi
Date:
On Fri, 17 Dec 2004 20:30:55 +0100, Andreas Kretschmer
<andreas_kretschmer@despammed.com> wrote:

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

You think right.. I should have searched more (it was right under my
nose)

>> 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?

:-)

Gino

Gino Lucrezi
Penta Consulting Services Srl