Not an option for what I'm doing. -----Original Message----- From: Rich Shepard [mailto:[EMAIL PROTECTED] Sent: Friday, March 09, 2007 5:19 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Is there an inverse for .import?
On Fri, 9 Mar 2007, Dennis Cote wrote: > You can get csv output from sqlite using the .mode command to specify the > output format and the .output command to set the output file. > > .mode csv > .headers on > .output mytable.csv > select * from mytable; > .output stdout Or, use the SQL format for both output and input. At the sqlite3> prompt, type .h(elp) and see all the choices. Rich -- Richard B. Shepard, Ph.D. | The Environmental Permitting Applied Ecosystem Services, Inc. | Accelerator(TM) <http://www.appl-ecosys.com> Voice: 503-667-4517 Fax: 503-667-8863 ------------------------------------------------------------------------ ----- To unsubscribe, send email to [EMAIL PROTECTED] ------------------------------------------------------------------------ ----- -------------------------------------------------------- NOTICE: If received in error, please destroy and notify sender. Sender does not intend to waive confidentiality or privilege. Use of this email is prohibited when received in error. ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
