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

On 9 Nov 2016, at 13:23, Alberto Ferrari aferrari@starconnecting.com wrote:

Hi Jennie, What Ariel is asking is about "COPY INTO FILE", and you refer to "COPY INTO TABLE”

Oeps, sorry. You’re right. Then I’m afraid this feature is not implemented yet in MonetDB.

If necessary, please file a feature request. This calls for something like:

WITH CSV HEADER, or FORMAT CSV WITH HEADER

Regards,

Jennie

Regards.

2016-11-09 0:08 GMT-03:00 Ying Zhang Y.Zhang@cwi.nl:

...

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

---

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