On Sun, 02 Dec 2007 13:42:17 +0100, Stefan Finzel <[EMAIL PROTECTED]> wrote:
>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 PRAGMA table_info(tablename); -- ( Kees Nuyt ) c[_] ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------