[sqlite] Suggestion for .import improvement

2015-05-12 Thread James K. Lowden
On Mon, 11 May 2015 22:24:53 +0300 wrote: > Current .import behavior is that when the imported table does not > exist, it will be created using the first row from the data file as > column names for the new table. Huh, somehow I'd forgotten that! > Once the initial table is created by the

[sqlite] Suggestion for .import improvement

2015-05-11 Thread to...@acm.org
I would like to request this improvement to the shell .import command. (Wish list, I guess.) Current .import behavior is that when the imported table does not exist, it will be created using the first row from the data file as column names for the new table. This is great but it has one

[sqlite] Suggestion for .import improvement

2015-05-11 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 05/11/2015 12:24 PM, tonyp at acm.org wrote: > It?s a real nuisance to have to edit out the headers every time, > especially when the files are very large and they do not load fast > (or at all) into a text editor. Plus, it?s semi-automatic. I