Received: from bush.rutgersinsurance.com (IDENT:root@rutgersinsurance.com [38.138.71.194]) by hub.org (8.10.1/8.10.1) with ESMTP id e7FCSKn19402 for ; Tue, 15 Aug 2000 08:28:21 -0400 (EDT) Received: from Adam ([10.10.10.51]) by bush.rutgersinsurance.com (8.9.3/8.9.3) with SMTP id IAA02408; Tue, 15 Aug 2000 08:31:53 -0400 Message-ID: <000c01c006b4$71fd9ce0$330a0a0a@Adam> From: "Adam Lang" To: "Stephan Szabo" Cc: References: Subject: Re: copy from Date: Tue, 15 Aug 2000 08:29:23 -0400 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 X-Archive-Number: 200008/105 I get it. I upload to the temp table, then for the select/insert I just do the nextval(seq_id) for the primary key field, correct? Adam Lang Systems Engineer Rutgers Casualty Insurance Company ----- Original Message ----- From: "Stephan Szabo" To: "Adam Lang" Cc: Sent: Monday, August 14, 2000 5:17 PM Subject: Re: [SQL] copy from > > One way would be to copy the data into a temporary table that doesn't > have the id field, and then > insert into table (fields) select * from temptable; > > Stephan Szabo > sszabo@bigpanda.com > > On Mon, 14 Aug 2000, Adam Lang wrote: > > > I need additional help involving the copy from command > > > > I have a database with several fields: id, name, address, zip > > > > id is the primary key and I use nextval to get a value. > > > > The file I want to upload is in comma separated value, that does not have a > > primry key (or an id) field. > > > > How would I use copy from and assign the correct id number? > > > > Adam Lang > > Systems Engineer > > Rutgers Casualty Insurance Company > >