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 :).

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