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
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
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
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
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.
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.
_
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
7 matches
Mail list logo