Postgres Pro
Downloads
Home   >   mailing lists

logging a script - Mailing list pgsql-sql

From Ken Kline
Subject logging a script
Date
Msg-id 3A934E9A.91B43BA4@oldbs.com
Whole thread Raw
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: "postgresql"
Date:
Subject: syntax prob
Next
From: Martijn van Oosterhout
Date:
Subject: Re: [GENERAL] two tables - foreign keys referring to each other...