Re: COPY FROM and sequences

On Jan 8, 2007, at 8:55 PM, Michael Glaesemann wrote:

>
> On Jan 8, 2007, at 19:20 , Matthew Terenzio wrote:
>
>> Is it true that you can't use COPY FROM to fill a table with a SERIAL
>> type column?
>>
>> Or rather, how does one approach that situation most effectively?
>
> Could you give an example of what you're trying to do? What errors are
> you getting?

Just trying to fill a large number of rows in a table that uses a
serial for the primary key, from a comma delimited file

  invalid input syntax for integer: ""

I'm not quoting anything, just leaving the the delimited field empty
and expected a seuqence would fill the column as it would in an insert


>
> Michael Glaesemann
> grzm seespotcode net
>
>
>