COPY isn't working right for me
От | Jeff S. |
---|---|
Тема | COPY isn't working right for me |
Дата | |
Msg-id | 20010213152830.81634.qmail@web12709.mail.yahoo.com обсуждение исходный текст |
Ответы |
Re: COPY isn't working right for me
|
Список | pgsql-sql |
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/
В списке pgsql-sql по дате отправления: