Re: [INTERFACES] libpq++ - copy - default values

From: "Thomas G(dot) Lockhart" <lockhart(at)alumni(dot)caltech(dot)edu>
To: "V(dot) A(dot)" <a2891891(at)smail(dot)Uni-Koeln(dot)DE>
Cc: Postgres-Interface <pgsql-interfaces(at)postgreSQL(dot)org>
Subject: Re: [INTERFACES] libpq++ - copy - default values
Date: 1999-03-04 14:08:55
Message-ID: 36DE93F7.ACFC09F1@alumni.caltech.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-interfaces by date

  From Date Subject
Next Message Randall W. Barrett 1999-03-04 14:09:44 Re: [INTERFACES] Postgre Perl on WIN NT
Previous Message Thomas G. Lockhart 1999-03-04 13:54:09 Re: [INTERFACES] Foreign Keys