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.html#csvread > CSVREAD(fileNameString <https://h2database.com/html/grammar.html#string> > [, columnsString <https://h2database.com/html/grammar.html#string> [, > csvOptions <https://h2database.com/html/grammar.html#csv_options> ] ] ) > > 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. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/aa42926c-890f-4851-925b-c124e32712ac%40googlegroups.com.
