Hi!
Is there a way to get the column names as part of the insert statment, like
INSERT INTO DefConfig (Class,Status,Var,Type,Val,Remark) VALUES
('sgLog','enabled','Log,PID','boolean','1','default');
instead of
INSERT INTO "DefConfig" VALUES
('sgLog','enabled','Log,PID','text','1','default');
Reason: There are nearly identical tables in several databases. Each of
them may be altered by users in column ordering or even may have
additional columns with default settings. With available column
information it would be more easy to transfer data between them:
sqlite3 default_db ".dump DefConfig" | egrep -v '^INSERT INTO ' |
sqlite3 user_db
I also miss the column names and table name using the output of a select
statement
sqlite3 default_db
sqlite> .mode insert
sqlite> SELECT Class, Var FROM DefConfig;
...
INSERT INTO table VALUES('sgLog','Log,PID');
...
sqlite>
TIA
Stefan
--
_________________________________________________________
Stefan G. R. Finzel, Dipl. Phys. (Univ.)
Ochsenkopfstr. 5, D-95478 Kemnath, +49 (0)9642 704448
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
