On Thursday, 13 February 2020 22:33:48 UTC+8, Rinse Lemstra wrote:
>
> Although the csv file does containt column names, they are not respected.
>
Hello.
The documentation of this function describes how to use custom names or use
column names from the file:
https://h2database.com/html/functions.
>From the docs: http://h2database.com/html/functions.html#csvread
"If the column names are specified (a list of column names separated with
the fieldSeparator), those are used, otherwise (or if they are set to NULL)
the first line of the file is interpreted as the column names"
On Thu, Feb 13, 2
with CSVREAD one can insert/merge records from a .csv file.
Although the csv file does containt column names, they are not respected.
Wouldn't it be nice if CSVREAD could respect these column names while
importing the data?
regards,
Rinse
--
You received this message because you are subscri