I am not using any programming language. I am simply using PostgreSQL 12 version that's all
Oracle has BLOB to store Binary data and PG has BYTEA.
In case you want to practice something like reading an image of your choice and storing the binary data in a table using Python and psycopg2, you could use the following example :
You would use some programming language and database driver to read or write such binary data usually, so the question was what were you using to practice or implement this migration stuff ?
and
What are you using to migrate the data from Oracle to PostgreSQL ?
and
What is the challenge in copying binary data from Oracle to PostgreSQL ?
On 8/13/20 6:49 AM, Naveen Kumar wrote: > I am trying to migrate the database from Oracle to PostgreSQL
The question was:
What programming language and database driver are you using?
> > On Thu, Aug 13, 2020 at 7:17 PM Adrian Klaver <adrian.klaver@aklaver.com > <mailto:adrian.klaver@aklaver.com>> wrote: > > On 8/13/20 6:40 AM, Naveen Kumar wrote: > > Can someone please give me an example on byteA data type. > > > > 1. How to import a image/text file into Bytea data type.? > > 2. How to export the same? > > What programming language and database driver are you using? > > -- > Adrian Klaver > adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com> >
