Re: COPY Question

Disregard this.  I went with a temp table solution.

Thanks,

Sam

Bruce Momjian wrote:
>
> > 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

--
 _____________________
/   Samuel A. Mullen  \
|  Programmer Analyst  |_______________________________________________
|  Opportunities Unl.  | My soul shall be satisfied as [with] marrow   \
\_____________________/| and fatness; and my mouth shall praise [thee] |
                       | with joyful lips:                             |
                       |                    Psalms 63:4                |
                       \_______________________________________________/