Hello Simon ! That's why I mentioned "would be a good idea to have the ".import" complement !
Why not have direct command ".export table_name" and internally it does all commands you mention in one go, simple and intuitively. If I saw an "import" command I also expected the "export" command, and it seems that I'm not alone. Cheers ! > Fri Mar 25 2016 03:49:37 PM CET from "Simon Slavin" ><slavins at bigfraud.org> Subject: Re: [sqlite] Help needed for COPY Command. > > On 25 Mar 2016, at 11:33am, Richard Hipp <drh at sqlite.org> wrote: > > >>On 3/25/16, Simon Slavin <slavins at bigfraud.org> wrote: >> >> >>>There is no COPY command in SQLite. >>> >> There *was* a COPY command, way back in SQLite 2.x. It was omitted >> from SQLite3, circa 2004. >> > Wow. > > On 25 Mar 2016, at 12:22pm, Domingo Alvarez Duarte ><sqlite-mail at dev.dadbiz.es> wrote: > > >>But discovered that it can be somehow emulated by "import tablename" using >> csv. >> >> Would be a good idea to have the complementary of ".import" -> ".export". >> > You can get export to .csv files using > > ..mode csv > ..once filename.txt > ..SELECT * FROM tablename > > If you want tabs instead of commas, use ".mode tabs" instead. > > Simon. > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > > ?