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 e7EKXWw75011 for ; Mon, 14 Aug 2000 16:33:32 -0400 (EDT) Received: from Adam ([10.10.10.51]) by bush.rutgersinsurance.com (8.9.3/8.9.3) with SMTP id QAA01899 for ; Mon, 14 Aug 2000 16:36:57 -0400 Message-ID: <02b701c0062f$081e31c0$330a0a0a@Adam> From: "Adam Lang" To: Subject: copy from Date: Mon, 14 Aug 2000 16:34: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/96 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