logging a script

From: Ken Kline <ken(at)oldbs(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: logging a script
Date: 2001-02-21 05:14:02
Message-ID: 3A934E9A.91B43BA4@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

Browse pgsql-sql by date

  From Date Subject
Next Message Stephan Szabo 2001-02-21 07:34:30 Re: [SQL] two tables - foreign keys referring to each other...
Previous Message Chris Czeyka 2001-02-21 05:09:49 Re: two tables - foreign keys referring to each other...