Re: [INTERFACES] libpq++ - copy - default values - Mailing list pgsql-interfaces

From Thomas G. Lockhart
Subject Re: [INTERFACES] libpq++ - copy - default values
Date
Msg-id 36DE93F7.ACFC09F1@alumni.caltech.edu
Whole thread Raw
In response to libpq++ - copy - default values  ("V. A." <a2891891@smail.Uni-Koeln.DE>)
List pgsql-interfaces
> 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

pgsql-interfaces by date:

Previous
From: "Thomas G. Lockhart"
Date:
Subject: Re: [INTERFACES] Foreign Keys
Next
From: "Randall W. Barrett"
Date:
Subject: Re: [INTERFACES] Postgre Perl on WIN NT