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: 265

Filed under:
|
|
|
|

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

Related posts about excel

Related posts about pgsql