Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

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: Sun, 28 Feb 2010 12:07:20 -0500
  • Message-id: <9955.1267376840@sss.pgh.pa.us> <text/plain>

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



Home | Main Index | Thread Index

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group