Hello,
I think the in numeric column you have inserted text data.So if your column
value is numeric and suppose it is 1 then use 1 instead of "1".
one more thing dont use delimiter after last column value in csv file.
example:
postgres=# create table abc (a varchar(10),b numeric);
CREATE TABLE
/home/aa.csv
"aaa",1
postgres=# COPY abc from '/home/aa.csv' DELIMITER ',';
COPY 1
Regards,
Vinayak
-----
Thanks and Regards,
Vinayak Pokale,
NTT DATA OSS Center Pune, India
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/PGSQL-9-3-2-COPY-command-issues-tp5811940p5811942.html
Sent from the PostgreSQL - novice mailing list archive at Nabble.com.