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