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