| From: | Robert Treat <xzilla(at)users(dot)sourceforge(dot)net> |
|---|---|
| To: | Alexander Stanier <alexander(dot)stanier(at)egsgroup(dot)com> |
| Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Importing BLOB to Postgresql |
| Date: | 2002-10-08 13:58:28 |
| Message-ID: | 1034085508.6801.21.camel@camel |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
You probably want to use bytea. Look up blob and lo_import in the
interactive docs for quite a bit more information.
Robert Treat
On Tue, 2002-10-08 at 06:02, Alexander Stanier wrote:
>
> I am migrating a database from Oracle to Postgresql. I have one Oracle
> table which contains BLOBs. Given that I can get the BLOBs out of Oracle
> to the filesystem, can anyone tell me how I can import them in
> postgresql?
>
> I am assuming that the BLOBs should be imported into a "bytea" datatype.
> Is this correct?
>
> Regards,
>
> Alex.
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2002-10-08 14:00:13 | Re: How to find out about index |
| Previous Message | Shridhar Daithankar | 2002-10-08 13:51:55 | Re: Hot Backup |