Re: [sqlite] export to SQL insert statements with column names

[EMAIL PROTECTED] wrote: > > Hi, > Is there a way to export/dump SQLite data into INSERT statements which > also have column names? > > As of now, a sqlite dump looks like this > > INSERT INTO "ric_tb_language" VALUES('ENG','English'); > INSERT INTO "ric_tb_language" VALUES('SPN','Spanish'); > I

Re: [sqlite] export to SQL insert statements with column names

[EMAIL PROTECTED] wrote: > Is there a way to export/dump SQLite data into INSERT statements which > also have column names? > No. You would have to build a custom version and modify the source of the dump command in shell.c. HTH Dennis Cote ___ sqlite

[sqlite] export to SQL insert statements with column names

Hi, Is there a way to export/dump SQLite data into INSERT statements which also have column names? As of now, a sqlite dump looks like this INSERT INTO "ric_tb_language" VALUES('ENG','English'); INSERT INTO "ric_tb_language" VALUES('SPN','Spanish'); INSERT INTO "ric_tb_language" VALUES('GER','Ger