[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: [GENERAL] Absent output from psql
From:       Tom Lane <tgl () sss ! pgh ! pa ! us>
Date:       2010-02-28 17:07:20
Message-ID: 9955.1267376840 () sss ! pgh ! pa ! us
[Download RAW message or body]

John Gage <jsmgage@gmail.com> writes:
> 1) EFN=# \o aatest01.txt \i ./TestQuery01.txt
> 2) EFN=# \i ./TestQuery01.txt

> After I execute line 1), the results of the two queries contained in the
> TestQuery01.txt file can be found in aatest01.txt.  Good.  Excellent.
> However, line 2) results in no output to any place I can discover.

Doesn't it get appended to aatest01.txt?  My recollection is that \o's
effects persist till you reset it.  But it only affects query output,
not interactive commands like \p.

			regards, tom lane

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
[prev in list] [next in list] [prev in thread] [next in thread]