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?

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

Thanks in advance

Gino

Gino Lucrezi
Penta Consulting Services Srl

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° ;-)

Does the psql option -e not provide what you're looking for?

George

----- Original Message -----
From: "Gino Lucrezi" <gino-pgadmin@lucrezi.net>
To: <pgsql-novice@postgresql.org>
Sent: Friday, December 17, 2004 6:48 AM
Subject: [NOVICE] how to echo SQL commands in the output of a script


>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?
>
> 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
>
> Thanks in advance
>
> Gino
>
> Gino Lucrezi
> Penta Consulting Services Srl
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>


---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

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