Re: COPY FROM and sequences

On Jan 8, 2007, at 9:13 PM, Matthew Terenzio wrote:

>
> 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

Looks like WITH NULL AS '' might work



>
>
>>
>> Michael Glaesemann
>> grzm seespotcode net
>>
>>
>>
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
>       subscribe-nomail command to majordomo@postgresql.org so that your
>       message can get through to the mailing list cleanly
>
>