Postgres Pro
Downloads
Home   >   mailing lists

logging a psql script - Mailing list pgsql-sql

From Ken Kline
Subject logging a psql script
Date
Msg-id 3A943843.CA8825F8@oldbs.com
Whole thread Raw
Responses Re: logging a psql script  (Frank Joerdens <frank@joerdens.de>)
Re: logging a psql script  ("Oliver Elphick" <olly@lfix.co.uk>)
Re: logging a psql script  (Christopher Sawtell <csawtell@xtra.co.nz>)
Re: logging a psql script  (Jeff Duffy <jduffy@greatbridge.com>)
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: Tom Lane
Date:
Subject: Re: now() with microsecond granulity needed
Next
From: Frank Joerdens
Date:
Subject: Re: logging a psql script