importing csv file into pgsql
Posted
by running4surival
on Stack Overflow
See other posts from Stack Overflow
or by running4surival
Published on 2010-05-10T20:04:02Z
Indexed on
2010/05/10
20:14 UTC
Read the original article
Hit count: 262
ok im trying to upload this csv file onto my table in pgsql
but im getting this error
ERROR: invalid input syntax for integer: "mlname,mfname,slname,sfname,address,postalcode,membershiptype,hphone,email"
CONTEXT: COPY members2, line 1, column id: "mlname,mfname,slname,sfname,address,postalcode,membershiptype,hphone,email"
i really understand why im getting this error, both my table and my csv file have the same column names
© Stack Overflow or respective owner