What sqlite versions, OS etc.? This worked for me:

$ sqlite3
SQLite version 3.2.8
Enter ".help" for instructions
sqlite> create table abc(a, b, c);
sqlite> .output out.txt
sqlite> select * from sqlite_master;
sqlite> .quit 
$ cat out.txt
table|abc|abc|2|CREATE TABLE abc(a, b, c)


> 
> How do I do this:
> From the command prompt issue a simple select query to a specified database
> and direct the output to a file.
> I can see there is the .output FILENAME option, but nothing seems to happen.
> .output stdout works fine with output to the screen.
> Must be overlooking something simple here.
> 
> RBS
> 
> 
> 
> -----------------------------------------------------------------------------
> To unsubscribe, send email to [EMAIL PROTECTED]
> -----------------------------------------------------------------------------
> 
> 



 
____________________________________________________________________________________
Sponsored Link

$200,000 mortgage for $660/ mo - 
30/15 yr fixed, reduce debt - 
http://yahoo.ratemarketplace.com

-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------

Reply via email to