Re: [SQL] copy into serial field with auto_increment

2001-04-19 Thread Oliver Elphick
Andy wrote: >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_incremen

[SQL] copy into serial field with auto_increment

2001-04-19 Thread Andy
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.