Re: COPY Question - Mailing list pgsql-general

From Bruce Momjian
Subject Re: COPY Question
Date
Msg-id 200004211510.LAA14726@candle.pha.pa.us
Whole thread Raw
In response to COPY Question  ("Samuel A. Mullen" <smullen@oppunl.com>)
List pgsql-general
> As you can see I'm delimiting the fields with a '|' character.  You will
> also notice that there is no field 1.  I was hoping that I could leave
> that blank and the sequence automatically fill in the PKEY.  Does this
> not work?

DEFAULTS are not activated by COPY.
--
  Bruce Momjian                        |  http://www.op.net/~candle
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

pgsql-general by date:

Previous
From: "Samuel A. Mullen"
Date:
Subject: COPY Question
Next
From: "Samuel A. Mullen"
Date:
Subject: Re: COPY Question