Re: PGSQL 9.3.2 COPY command issues

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.