Received: from golem.jpl.nasa.gov (IDENT:root@hectic-1.jpl.nasa.gov
	[128.149.68.203]) by hub.org (8.9.2/8.9.1) with ESMTP id JAA25934
	for <pgsql-interfaces@postgreSQL.org>;
	Thu, 4 Mar 1999 09:09:23 -0500 (EST)
	(envelope-from lockhart@alumni.caltech.edu)
Received: from alumni.caltech.edu (localhost [127.0.0.1])
	by golem.jpl.nasa.gov (8.8.5/8.8.5) with ESMTP id OAA07027;
	Thu, 4 Mar 1999 14:08:55 GMT
Sender: tgl@mythos.jpl.nasa.gov
Message-ID: <36DE93F7.ACFC09F1@alumni.caltech.edu>
Date: Thu, 04 Mar 1999 14:08:55 +0000
From: "Thomas G. Lockhart" <lockhart@alumni.caltech.edu>
Organization: Caltech/JPL
X-Mailer: Mozilla 4.07 [en] (X11; I; Linux 2.0.36 i686)
MIME-Version: 1.0
To: "V. A." <a2891891@smail.Uni-Koeln.DE>
CC: Postgres-Interface <pgsql-interfaces@postgreSQL.org>
Subject: Re: [INTERFACES] libpq++ - copy - default values
References: <00af01be6641$2e5851c0$0200a8c0@Tischrechner.rrz.uni-koeln.de>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

> My problem is, that I don't know how I can tell the copy-command to
> leave the first field untouched, so that it gets the default value 
> from a sequence....
> Can anyone tell me, how I can do this?

afaik "copy" always fills all columns. You might get better results
using a series of inserts, which do allow default values to be used.

                       - Tom