Received: from c014.sfo.cp.net (c014-h022.c014.sfo.cp.net [209.228.12.86]) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id f1LLnmx33607 for ; Wed, 21 Feb 2001 16:49:48 -0500 (EST) (envelope-from ken@oldbs.com) Received: (cpmta 25580 invoked from network); 21 Feb 2001 13:49:30 -0800 Received: from unknown (HELO oldbs.com) (216.91.245.19) by smtp.oldbs.com (209.228.12.86) with SMTP; 21 Feb 2001 13:49:30 -0800 X-Sent: 21 Feb 2001 21:49:30 GMT Message-ID: <3A943843.CA8825F8@oldbs.com> Date: Wed, 21 Feb 2001 16:51:00 -0500 From: Ken Kline X-Mailer: Mozilla 4.76 [en] (X11; U; Linux 2.2.16-22min_for_stan i586) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: logging a psql script Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200102/331 X-Sequence-Number: 1527 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