Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: [INTERFACES] libpq++ - copy - default values
Date
Msg-id 28014.920558910@sss.pgh.pa.us
Whole thread Raw
In response to libpq++ - copy - default values  ("V. A." <a2891891@smail.Uni-Koeln.DE>)
List pgsql-interfaces
Tree view 
"V. A." <a2891891@smail.Uni-Koeln.DE> writes:
> 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....

You can't.  COPY is for plain verbatim dumping and reloading of data.
Use INSERT if you need to have any calculations done.

            regards, tom lane

pgsql-interfaces by date:

Previous
From: "Randall W. Barrett"
Date:
Subject: Re: [INTERFACES] Postgre Perl on WIN NT
Next
From: Tom Lane
Date:
Subject: Re: [INTERFACES] Postgre Perl on WIN NT