Re: Absent output from psql

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: John Gage <jsmgage(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Absent output from psql
Date: 2010-02-28 17:07:20
Message-ID: 9955.1267376840@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

John Gage <jsmgage(at)gmail(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message rihad 2010-02-28 19:26:54 Re: Partial foreign keys
Previous Message Nilesh Govindarajan 2010-02-28 16:47:10 Re: Absent output from psql