OK .. my offending line number is 4533
How can i remove it while copying ?
*COPY Table
FROM 'insert .csv dir here'
USING DELIMITERS ';' CSV HEADER*
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Error-while-importing-CSV-file-tp5458103p5462255.html
Sent from the Pos
*
ok then if I want to except that row from copying. how i can write it ?*
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Error-while-importing-CSV-file-tp5458103p5459976.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
--
Sent via pgsql-gene
I've tried a lot of sizes
but I still have messages in my log saying:
* ---
ERROR: value too long for type character varying(200)
--- *
Why is this? There are no other varchar(200) columns in my DB at all,
no other table. Only this column used to be 25 characters and using
the alter ty
no not all of rows
is that gonna work ?
thanks
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Error-while-importing-CSV-file-tp5458103p5459396.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
--
Sent via pgsql-general mailing list (pgsql-ge
OK that problem solved
Thanks so much
but I had another problem
*ERROR: value too long for type character varying(100)*
although in the original file it was varying(25) only !!
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Error-while-importing-CSV-file-tp5458103p54
Thanks but still i get this :
*ERROR: invalid input syntax for integer: "id"*
(1st col only)
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Error-while-importing-CSV-file-tp5458103p5459334.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
--
