Re: [sqlite] Import data into a temporary table

2019-03-07 Thread Keith Medcalf
On Thursday, 7 March, 2019 17:12, D Burgess wrote: >The big downside of the csv extension, is that no matter what you do >your table ends up with every column with a type of text. >A trap if you are you are using union/except/intersect clauses. You are more or less but not entirely correct. If

Re: [sqlite] Import data into a temporary table

2019-03-07 Thread Dianne Dunn
Not sure how I got this please remove me Sent from my iPad > On Mar 7, 2019, at 4:00 PM, Keith Medcalf wrote: > > > On Thursday, 7 March, 2019 14:45, Eric Tsau asked: > >> Is it possible to add the option of importing data into a temporary >> table? > >> Currently you have to create a tempo

Re: [sqlite] Import data into a temporary table

2019-03-07 Thread Keith Medcalf
I should have said that "It appears that you are correct, the .import shell command does not know how to create a table in other than the default "main" schema" and that you are requesting this be changed so that the table being imported into does get created in the specified schema if a the ta

Re: [sqlite] Import data into a temporary table

2019-03-07 Thread D Burgess
The big downside of the csv extension, is that no matter what you do your table ends up with every column with a type of text. A trap if you are you are using union/except/intersect clauses. On Fri, Mar 8, 2019 at 11:00 AM Keith Medcalf wrote: > > On Thursday, 7 March, 2019 14:45, Eric Tsau as

Re: [sqlite] Import data into a temporary table

2019-03-07 Thread Keith Medcalf
On Thursday, 7 March, 2019 14:45, Eric Tsau asked: >Is it possible to add the option of importing data into a temporary >table? >Currently you have to create a temporary table first before importing >to it, or having to drop the table afterwards. >.import dump.csv temp.table >or >.import dump.

Re: [sqlite] Import data into a temporary table

2019-03-07 Thread Simon Slavin
On 7 Mar 2019, at 9:45pm, Eric Tsau wrote: > Is it possible to add the option of importing data into a temporary table? Can you rephrase your request ? You can import data into a temporary table > .import dump.csv temp.table Does this command not work correctly ? Simon. _

[sqlite] Import data into a temporary table

2019-03-07 Thread Eric Tsau
Hi, Is it possible to add the option of importing data into a temporary table? Currently you have to create a temporary table first before importing to it, or having to drop the table afterwards. .import dump.csv temp.table or .import dump.csv attach.table Regards Eric