Re: COPY subquery INTO file_name - INCLUDE field name

On 31 Oct 2016, at 18:42, Ariel Abadi 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