Hi,
Thanks. Thinking about sticking the select...csvread... into another
> SQL statement as you have done suggests this variation:
>
> insert into iris0 (select * from csvread('iris3.dat')
> select * from iris0
>
> where iris0 comes from a zero row data frame in R of the same form as
> iris3.dat that I can upload to H2 from R using facilities I already
> have.
>
The combination "create table ... as select ... from csvread..." is a bit
faster, but maybe this doesn't matter too much.
Regards,
Thomas
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en.
