There are two problems here:
a) You're using a column keyword that doesn't exist; what you'd want
to do normally is:
copy MyTableName (contactname,addr,city,zipcode) from 'pathtomycsvfile' with null as '' csv header quote as '"' escape as '"' ;
b) You can't import parts of a csv; every column in the CSV must
be matched in your table structure. Look at PGLoader, or sanitise
your data ...