Hello, i've got a textfile of data separated by '|'. One of the fields in my table is a serial (auto_increment) field. When i import the data with the copy command i get duplicate key error. The key is the serial - field. I recognized that the copy command doesn't auto_increment the serial field. I come from mysql and pushed a 0 into the serial field. But it doesn't work. I tested it with an empty field, but it failed to. How could i make it work ?? Thanx for every help -- Andy - Kim Möller Leiter Lastminute / Pauschal - Deutschland ypsilon.net AG Leiter Entwicklungsabteilung Lastminute / Pauschal / Mietwagen - Deutschland ypsilon.net AG Tel.: (06109) - 50 50 FAX : (06109) - 50 525 eMail : [EMAIL PROTECTED]
begin:vcard n:Möller;Andy-Kim tel;cell:0179/2302856 tel;fax:06109 / 505 25 tel;home:06661/4526 tel;work:06109 / 505 193 x-mozilla-html:FALSE url:http://www.ypsilon.net org:i. A. d. F. Ypsilon - Network GmbH;Database - Managment & Software - Development adr:;;Vilbeler Landstr. 203;Frankfurt;Hessen;60388;Germany version:2.1 email;internet:[EMAIL PROTECTED] fn:Andy-Kim Möller end:vcard
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
