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
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
