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.
>