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]
-----------------------------------------------------------------------------
