Chris Gordon wrote:
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?
That's by design - it just shows results by default. I think you want to
capture STDOUT/ERR rather like this:
$ psql --echo-all -Urichardh
I am coming from Oracle & mySQL. In Oracle I can use
spool foo.txt
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;
