Re: COPY not handling BLOBs

Doug McNaught wrote:

>David Rysdam <drysdam(at)ll(dot)mit(dot)edu> writes:
>
>
>
>>Right now I'm having to write a program to create all the large
>>objects up front and record the OIDs in a file which I will then COPY
>>in with the rest of my data.
>>
>>
>
>You might consider using "bytea" instead of large objects, unless you
>need the lo_read()/lo_seek() API in your client app... I'm not
>super-familiar with how bytea and COPY work together, though.
>
>-Doug
>
>
bytea will only go up to "several thousand bytes" according to the
docs. I assume it's not very precise because the maximum is 8196 -
$other_fields_in_row. My binary data could be a couple times that or
even much bigger for other apps.