--- "Gauthier, Dave" <[EMAIL PROTECTED]> wrote: > But how can I ".mode column" and ".header on" as well as run the query
If you're using bash (ksh and sh might work as well): $ echo -e ".header on\n.mode column\nselect * from sqlite_master;" | ./sqlite3 abc.db type name tbl_name rootpage sql ---------- ---------- ---------- ---------- ----------------------- table abc abc 2 CREATE TABLE abc(a,b,c) table xyz xyz 3 CREATE TABLE xyz(x,y,z) or if you have printf(1): $ printf ".header on\nselect * from sqlite_master;" | ./sqlite3 abc.db type|name|tbl_name|rootpage|sql table|abc|abc|2|CREATE TABLE abc(a,b,c) table|xyz|xyz|3|CREATE TABLE xyz(x,y,z) See also: http://www.sqlite.org/cvstrac/wiki?p=ShellScript ____________________________________________________________________________________ Got a little couch potato? Check out fun summer activities for kids. http://search.yahoo.com/search?fr=oni_on_mail&p=summer+activities+for+kids&cs=bz ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
