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 Davi

[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 l