Re: Importing BLOB to Postgresql

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