Hi,
Yes you were right. Skipping the header is not automatical.
Thank you very much,
Jiri N.
From: users-list [mailto:users-list-bounces+nadvornik.ji=gmail.com@monetdb.org] On Behalf Of Pavel Stehule Sent: 27. února 2015 12:56 To: Communication channel for MonetDB users Subject: Re: Import from PostgreSQL
Hi
On Fri, Feb 27, 2015 at 12:45 PM, Jiří Nádvorník nadvornik.ji@gmail.com wrote:
Hi All,
I'm trying to migrate my data from postgresql to monetDB. I only need one table without privileges and such, so I decided to export it to csv and create a table in monetdb.
Then when I run the copy command, the following error occurs. $ mclient -u caucau -d demo -s " copy into bextract.observation from stdin" - < bextract_observation.csv value 'obsname_id' from line 1 field 1 not inserted, expecting type int failed to import table
I am quite sure the number is an integer :).
you have to skip first line with header probably - use a OFFSET clause in COPY statement
Regards
Pavel Stehule
The DD file and data file are attached.
Thank you very much for answers,
Jiri Nadvornik
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list