On Friday 09 August 2002 17:01, you wrote: > Marvin Pascual wrote: > > > -----Original Message----- > > > From: [EMAIL PROTECTED] > > > [mailto:[EMAIL PROTECTED]]On Behalf Of Lemuel Tomas > > > Sent: Friday, August 09, 2002 1:46 AM > > > To: [EMAIL PROTECTED] > > > Subject: Re: [plug] Oracle 9iAS on Linux > > > > > > > > > > > > i assume you want to output a query to a file? > > > \o <file name> > > > > You mean, I'll just type first: > > > > =# \o temp.lst > > =# select * from table_name; > > > > So what's the spool off? > > after the select, the file is autoclosed :) > <snip>
on one box running pg7.1.1-4 you have to issue a "\o" to close the output file. hth, -eric -- �.--. �Enrique D. Rosel II ( () ) Q Linux Solutions, Inc. �`--\\ A Philippine Open Source Solutions Co. �http://www.q-linux.com/ _ Philippine Linux Users Group. Web site and archives at http://plug.linux.org.ph To leave: send "unsubscribe" in the body to [EMAIL PROTECTED] To subscribe to the Linux Newbies' List: send "subscribe" in the body to [EMAIL PROTECTED]
