Writing output to a file - Mailing list pgsql-general

From Chris Gordon
Subject Writing output to a file
Date
Msg-id ddb8f5230511291718r4756679fk6f66f15904226dbd@mail.gmail.com
Whole thread Raw
Responses Re: Writing output to a file  (Richard Huxton <dev@archonet.com>)
List pgsql-general
I am coming from Oracle & mySQL.  In Oracle I can use

spool foo.txt

<SQL>

spool off

After this the file foo.txt shows everything the screen showed.  If I had echo on it will show the command and results.  If I turn on timing it shows there too.

With mySQL similarly I can use tee foo.txt and notee;

I have used \o foo.txt and it seems to write significantly less than what I see on the screen.  Has anyone had experience with this?

--
The Gordons
TheGordonEmail@gmail.com
chrisgordon@truman.edu

pgsql-general by date:

Previous
From: Tyler MacDonald
Date:
Subject: Re: undefined behaviour for sub-transactions?
Next
From: "John D. Burger"
Date:
Subject: Finding uniques across a big join