Re: COPY not handling BLOBs

David Rysdam <drysdam@ll.mit.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
--
Let us cross over the river, and rest under the shade of the trees.
   --T. J. Jackson, 1863