> > That should have been obvious if you'd attempted to select > > something from the table with headers turned on in the command > > line utility. > > Thank you so much, and sorry for sending this stupid > question.
No apologies necessary, except for me. Re-reading that passage, it looks much harsher than I meant it. Sorry about that. I merely meant it as a suggestion for *next* time something like that happens. > Sometimes things ar just too obvious to be seen (in > french, we say they are "on one's nose"). In English, "right in front of one's nose". :) > In fact, as the table was empty, I did not know how to start the > troubleshooting. I tried to dump the table, but sqlite keeps > the exact formatting of the sql instruction : In the command line utility, the ".header" option controls the display of the column names when you do a select. I didn't notice your problem right off either, so I just created the table and selected from it to see the extra column.
