Re: Writing output to a file

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 richardh < test.sql > res.sql 2>&1

$ cat test.sql
\qecho hello world
\timing
SELECT * FROM nametest;
\d nametest

$ cat res.sql
\qecho hello world
hello world
\timing
Timing is on.
SELECT * FROM nametest;
  first | last | extra
-------+------+-------
(0 rows)

Time: 5.526 ms
\d nametest
           Table "public.nametest"
  Column |         Type          | Modifiers
--------+-----------------------+-----------
  first  | character varying(32) |
  last   | character varying(32) |
  extra  | character varying(32) |


That any help?

--
   Richard Huxton
   Archonet Ltd