Yes, unlike .dump, that works. Thanks very much. jim
-----Original Message----- From: Dennis Cote [mailto:[EMAIL PROTECTED] Sent: Friday, March 09, 2007 5:05 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Is there an inverse for .import? Anderson, James H (IT) wrote: > I need to "export" a table to a file in the same format as used by > .import, but I don't see any such cmd. Am I missing something, or does > such a cmd just not exist? > > jim > > 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 HTH Dennis Cote ------------------------------------------------------------------------ ----- To unsubscribe, send email to [EMAIL PROTECTED] ------------------------------------------------------------------------ ----- ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------