Received: from mail.postgresql.org (webmail.postgresql.org [216.126.85.28]) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id f1O3b7x42168 for ; Fri, 23 Feb 2001 22:37:07 -0500 (EST) (envelope-from pgsql-sql-owner@postgresql.org) Received: from c014.sfo.cp.net (c014-h003.c014.sfo.cp.net [209.228.12.67]) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id f1L5Iox19451 for ; Wed, 21 Feb 2001 00:18:50 -0500 (EST) (envelope-from ken@oldbs.com) Received: (cpmta 10707 invoked from network); 20 Feb 2001 21:12:41 -0800 Received: from unknown (HELO oldbs.com) (216.91.245.19) by smtp.oldbs.com (209.228.12.67) with SMTP; 20 Feb 2001 21:12:41 -0800 X-Sent: 21 Feb 2001 05:12:41 GMT Message-ID: <3A934E9A.91B43BA4@oldbs.com> Date: Wed, 21 Feb 2001 00:14:02 -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 script Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200102/373 X-Sequence-Number: 1574 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