I am trying to copy data from an ascii file into the table;
I get following error. can anybody explain why? solution if possible;
copy: line 1, pg_atoi: error in "tom": can't parse "tom "
create sequence film_id start 1;
create table zuser ( film_id int4 default NEXTVAL('film_id'), name
char(10));
data file has following contents:
unbreakable
sixthsense
nerds
buggy
Sandeep