logging a psql script

From: Ken Kline <ken(at)oldbs(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: logging a psql script
Date: 2001-02-21 21:51:00
Message-ID: 3A943843.CA8825F8@oldbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hello,
I would like my psql script to log everything that it does.
I set the following

\set ECHO all
\o foo.txt
\qecho

some sql, some ddl, etc...

\o

But foo.txt only contains

DROP
DROP
DROP
CREATE
CREATE
CREATE

I want it to contain everything that I see on the screen, what am I
missing?

Thanks

Ken

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2001-02-21 21:55:33 Re: now() with microsecond granulity needed
Previous Message Tom Lane 2001-02-21 21:04:41 Re: pl/Perl