On 31 Oct 2016, at 18:42, Ariel Abadi aabadi@starconnecting.com wrote:
Hi! We are using the COPY subquery INTO file_name [ [USING] DELIMITERS field_separator [',' record_separator [ ',' string_quote ]]] [ NULL AS null_string ]
BUT we need to have in the file the name of the fields on the first row.
Hai Ariel,
Is this what you’re looking for:
https://www.monetdb.org/Documentation/Cookbooks/SQLrecipes/LoadingBulkData
"Often CSV files contain header information that is not part of the actual data. This header information can be skipped by using the form
COPY n OFFSET m RECORDS INTO table FROM 'file';
Here n is the number of records to insert and m is the first record to be inserted where the first record in the file is called 1 (i.e. counting is 1 based).”
Regards, Jennie
Im looking on the documentation, but I cannot find anything related to this, can someone help me with this?
Thks in advance!
users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list