[SQL] COPY isn't working right for me

2001-02-13 Thread Jeff S.
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

Re: [SQL] COPY isn't working right for me

2001-02-13 Thread Peter Eisentraut
Jeff S. writes: 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