> 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

_______________________________________________
users-list mailing list
users-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/users-list