importing csv file into pgsql

Question

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

members2 is the name of the table and all my columns are charvar, so i dont see how it can be telling me anything about integers

Answer 1

Your problem is not the field names... The problem is that you're trying to input something into an integer field which is not an integer...

as far as i can see.. you're trying to insert a string into field members2...