Re: COPY not handling BLOBs - Mailing list pgsql-general

From Doug McNaught
Subject Re: COPY not handling BLOBs
Date
Msg-id 874qniu704.fsf@asmodeus.mcnaught.org
Whole thread Raw
In response to COPY not handling BLOBs  (David Rysdam <drysdam@ll.mit.edu>)
Responses Re: COPY not handling BLOBs
List pgsql-general
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

pgsql-general by date:

Previous
From: Prabu Subroto
Date:
Subject: altering the datatype of a column.
Next
From: Tom Lane
Date:
Subject: Re: Casting timestamp with time zone to varchar automatically