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

begin Gino Lucrezi <gino-pgadmin(at)lucrezi(dot)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° ;-)