copy table from... - Mailing list pgsql-general

From Sandeep Joshi
Subject copy table from...
Date
Msg-id 3A1B0343.1216887@zambeel.com
Whole thread Raw
Responses Re: copy table from...
List pgsql-general
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


pgsql-general by date:

Previous
From: Dave Smith
Date:
Subject: Re: Trying to build 7.0.3 on SCO 5.0.4
Next
From: oberpwd@anubis.network.com (Wade D. Oberpriller)
Date:
Subject: Core dumps, i.e. how to track down a problem