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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
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:48:30
Message-ID: 28014.920558910@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

"V. A." <a2891891(at)smail(dot)Uni-Koeln(dot)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

Browse pgsql-interfaces by date

  From Date Subject
Next Message Tom Lane 1999-03-04 14:59:40 Re: [INTERFACES] Postgre Perl on WIN NT
Previous Message Randall W. Barrett 1999-03-04 14:09:44 Re: [INTERFACES] Postgre Perl on WIN NT