Received: from web12709.mail.yahoo.com (web12709.mail.yahoo.com [216.136.174.56]) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id f1DFSYx89118 for ; Tue, 13 Feb 2001 10:28:34 -0500 (EST) (envelope-from pgsqluser@yahoo.com) Message-ID: <20010213152830.81634.qmail@web12709.mail.yahoo.com> Received: from [24.4.151.54] by web12709.mail.yahoo.com; Tue, 13 Feb 2001 07:28:30 PST Date: Tue, 13 Feb 2001 07:28:30 -0800 (PST) From: "Jeff S." Subject: COPY isn't working right for me To: pgsql-sql@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Archive-Number: 200102/249 X-Sequence-Number: 1440 I have a tab delimited file that I'm trying to import into an empty table. I've set the table up as follows: create table member ( member_id serial not null, fname varchar(25) not null, lname varchar(25) not null, member_since date not null, Primary Key (member_id) ); My member.txt file looks like this: Joe Smith 2000/01/14 Frank Jones 2000/06/21 Mike Davis 2000/09/24 Here's the copy command I use: COPY member FROM '/tmp/member.txt'; But I'm getting the following error: ERROR: copy: line 1, pg_atoi: error in "Joe": can't parse "Joe" I'm assuming this has to do with the member_id with type serial. How do I import into this without having to add the OID's to each of the rows in the text file? __________________________________________________ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/