| From: | David Rysdam <drysdam(at)ll(dot)mit(dot)edu> |
|---|---|
| To: | Postgres General <pgsql-general(at)postgresql(dot)org> |
| Subject: | COPY not handling BLOBs |
| Date: | 2004-08-04 17:17:48 |
| Message-ID: | 41111A3C.3000404@ll.mit.edu |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
I have a bunch of data in Sybase and some of it is in image fields. We
use bcp on this data transparently all the time without major issues in
character mode. Is there a fundamental technical reason that BLOBs
can't be COPY'd in postgresql or is it just that nobody has ever wanted
to before?
(If I was starting from scratch I'd probably be happy with
pg_dump/pg_restore, but I'd like to migrate in easy stages over from
Sybase, so I'd like the bcp files to be interchangable.)
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jim C. Nasby | 2004-08-04 17:41:30 | Re: Casting timestamp with time zone to varchar automatically |
| Previous Message | DeJuan Jackson | 2004-08-04 16:56:24 | Re: Recursive PLPGSQL function? |