Postgres Pro
Downloads
Home   >   mailing lists

Re: Oracle blob to Postgre bytea - Mailing list pgsql-novice

From Steve Baldwin
Subject Re: Oracle blob to Postgre bytea
Date
Msg-id CAKE1AibM9t7HfoEtgfXH=9hdA=g3JaACb+EEkdBEWi0JMLA4sg@mail.gmail.com
Whole thread Raw
In response to Oracle blob to Postgre bytea  (Chamath Sajeewa <csgsajeewa@gmail.com>)
List pgsql-novice
Tree view
Reading this it looks like you need to set the LONGREADLEN environment variable. Are you doing that?

On Thu, Jul 23, 2020 at 2:53 PM Chamath Sajeewa <csgsajeewa@gmail.com> wrote:
Hi,
I have migrated a oracle table with blob column to postgres using ora2pg tool. How ever only 1mb of the blob data is migrated. Any idea?
Thank you!

pgsql-novice by date:

Previous
From: Chamath Sajeewa
Date:
Subject: Oracle blob to Postgre bytea
Next
From: Preuß, Sylvia
Date:
Subject: Copy SQL from main window to query tool