Re: COPY subquery INTO file_name - INCLUDE field name

Hi Jennie, What Ariel is asking is about "COPY INTO FILE", and you refer to "COPY INTO TABLE" Regards. 2016-11-09 0:08 GMT-03:00 Ying Zhang :

...

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

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