You don't indicate how you're executing the copy. If you're using a script/program, just add your own counter as the first field in the copy. I do this 'all the time' from Perl scripts, and it works fine. If you're using psql, I haven't a clue unless you massage the input data before doing the copy. Rob > -----Original Message----- > From: Przemyslaw 'Morp][ik' Berlinski > [mailto:[EMAIL PROTECTED]] > Sent: Sunday, July 22, 2001 1:13 PM > To: [EMAIL PROTECTED] > Subject: [GENERAL] Copy and serial type problem > > > Hi, > > I've created a small table: > > CREATE TABLE "table" ( > "id" int4 DEFAULT nextval('"table_idd_seq"') NOT NULL, > "file" character varying(40) NOT NULL > ); > > Table sequence 'table_idd_seq' is also available with a next > id number. > > Question is how to use postgres copy function with this 'id'. > Table 'table' > is not empty... I've tried to insert nextval("table_idd_seq") > into file but > it doesn't work. > > Any help would be appreciated. > > TIA > Morp][ik > > > > > ---------------------------(end of > broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to > [EMAIL PROTECTED]) > ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
