Thread: Bytea Example
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?
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
I am trying to migrate the database from Oracle to PostgreSQL
On Thu, Aug 13, 2020 at 7:17 PM Adrian Klaver <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
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> > -- Adrian Klaver adrian.klaver@aklaver.com
I am not using any programming language. I am simply using PostgreSQL 12 version that's all
On Thu, Aug 13, 2020 at 7:21 PM Adrian Klaver <adrian.klaver@aklaver.com> wrote:
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>
>
--
Adrian Klaver
adrian.klaver@aklaver.com
On 8/13/20 6:56 AM, Naveen Kumar wrote: > I am not using any programming language. I am simply using PostgreSQL 12 > version that's all I'm having a hard time figuring out how you are migrating from Oracle to Postgres without using at least SQL and some sort of driver to pull out of one and push into the other. > > On Thu, Aug 13, 2020 at 7:21 PM Adrian Klaver <adrian.klaver@aklaver.com > <mailto:adrian.klaver@aklaver.com>> wrote: > > 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> > > <mailto: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> > <mailto:adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>> > > > > > -- > Adrian Klaver > adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com> > -- Adrian Klaver adrian.klaver@aklaver.com
On Thursday, August 13, 2020, Naveen Kumar <naveenmcp@gmail.com> 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?
At a simple level its no different than importing and exporting character data using a “text/varchar” field or a number using an integer field. For bytea the content is just raw bytes instead of characters or numbers.
David J.
sorry for the late reply. Below is my issue:
I am connected to PostgreSQL in a Windows environment. Below is my version:
"PostgreSQL 12.3, compiled by Visual C++ build 1914, 64-bit"
I am just trying to practice LOB objects, like byteA data type, in PostgreSQL. Unfortunately, I didn't find good links regarding this so I raised the issue. Nothing else I am doing.
Thank you one and all !!
Thanks & Regards
Naveen
On Thu, Aug 13, 2020 at 7:34 PM Adrian Klaver <adrian.klaver@aklaver.com> wrote:
On 8/13/20 6:56 AM, Naveen Kumar wrote:
> I am not using any programming language. I am simply using PostgreSQL 12
> version that's all
I'm having a hard time figuring out how you are migrating from Oracle to
Postgres without using at least SQL and some sort of driver to pull out
of one and push into the other.
>
> On Thu, Aug 13, 2020 at 7:21 PM Adrian Klaver <adrian.klaver@aklaver.com
> <mailto:adrian.klaver@aklaver.com>> wrote:
>
> 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>
> > <mailto: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>
> <mailto:adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>>
> >
>
>
> --
> Adrian Klaver
> adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
>
--
Adrian Klaver
adrian.klaver@aklaver.com
Naveen: 1st, do not top post, it is frowned upon here. AAMOF I was tempted to skip your message due to this, as it makes replying too hard. AK asked you (twice), "What programming language and database driver are you using?" On Sun, Aug 16, 2020 at 7:11 PM Naveen Kumar <naveenmcp@gmail.com> wrote: > I am connected to PostgreSQL in a Windows environment. Below is my version: > "PostgreSQL 12.3, compiled by Visual C++ build 1914, 64-bit" AK question is relevant because pg is a client-server database. I assume you have the server correctly installed and running, but we need to know what client software you are using, i.e.... - "I'm using the bundled psql command line program." In this case you interact by sending sql commands directly (I'm not able to put a sample because I never use bytea from psql, but many on this list do and can help you. - "I'm using pgAdmin4", and some pgAdmin user can help you. - "I'm using a C program using libpq" - "I'm using a Java program using JDBC" > I am just trying to practice LOB objects, like byteA data type, in PostgreSQL. Unfortunately, I didn't find good linksregarding this so I raised the issue. Nothing else I am doing. There are lot of links, many people know them by heart, but you need to help them by answering the question. The driver/language phrasing in AK question is because normally no one uses a plain sql ( psql/pgadmin) tool for LOBs, but if you do there are links which can be provided. Bear in mind that for all we know you could be connecting using your own gopher based tool which translates coloquial swahili to sql. Francisco Olarte.
OP originally wrote that he needs to exports and import them, so presumably he's just using psql. On 8/16/20 12:33 PM, Francisco Olarte wrote: > Naveen: > > 1st, do not top post, it is frowned upon here. AAMOF I was tempted to > skip your message due to this, as it makes replying too hard. > > AK asked you (twice), "What programming language and database driver > are you using?" > > On Sun, Aug 16, 2020 at 7:11 PM Naveen Kumar <naveenmcp@gmail.com> wrote: >> I am connected to PostgreSQL in a Windows environment. Below is my version: >> "PostgreSQL 12.3, compiled by Visual C++ build 1914, 64-bit" > AK question is relevant because pg is a client-server database. I > assume you have the server correctly installed and running, but we > need to know what client software you are using, i.e.... > > - "I'm using the bundled psql command line program." > In this case you interact by sending sql commands directly (I'm not > able to put a sample because I never use bytea from psql, but many on > this list do and can help you. > > - "I'm using pgAdmin4", and some pgAdmin user can help you. > > - "I'm using a C program using libpq" > > - "I'm using a Java program using JDBC" > >> I am just trying to practice LOB objects, like byteA data type, in PostgreSQL. Unfortunately, I didn't find good linksregarding this so I raised the issue. Nothing else I am doing. > There are lot of links, many people know them by heart, but you need > to help them by answering the question. > > The driver/language phrasing in AK question is because normally no one > uses a plain sql ( psql/pgadmin) tool for LOBs, but if you do there > are links which can be provided. > > Bear in mind that for all we know you could be connecting using your > own gopher based tool which translates coloquial swahili to sql. > > Francisco Olarte. > > -- Angular momentum makes the world go 'round.
Hi Naveen,
It's not easy for us to read if you top post. Always reply inline please.
On Thu, Aug 13, 2020 at 10:57 AM Naveen Kumar <naveenmcp@gmail.com> wrote:
Oracle has BLOB to store Binary data and PG has BYTEA.I am not using any programming language. I am simply using PostgreSQL 12 version that's all
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 Thu, Aug 13, 2020 at 7:21 PM Adrian Klaver <adrian.klaver@aklaver.com> wrote: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>
>
--
Adrian Klaver
adrian.klaver@aklaver.com
Regards,
Avinash Vallarapu
Avinash Vallarapu
On 8/16/20 10:10 AM, Naveen Kumar wrote:
> sorry for the late reply. Below is my issue:
>
> I am connected to PostgreSQL in a Windows environment. Below is my version:
>
> *"PostgreSQL 12.3, compiled by Visual C++ build 1914, 64-bit"*
>
> I am just trying to practice LOB objects, like byteA data type, in
> PostgreSQL. Unfortunately, I didn't find good links regarding this so I
> raised the issue. Nothing else I am doing.
Some simple examples:
create table bytea_test(byte_fld bytea);
insert into bytea_test values('\xDEADBEEF');
select * from bytea_test ;
byte_fld
------------
\xdeadbeef
insert into bytea_test values(decode('test string', 'escape'));
select * from bytea_test ;
byte_fld
--------------------------
\xdeadbeef
\x7465737420737472696e67
select encode(byte_fld, 'escape') from bytea_test ;
encode
------------------
\336\255\276\357
test string
From docs:
https://www.postgresql.org/docs/12/datatype-binary.html
https://www.postgresql.org/docs/12/functions-binarystring.html
As pointed out by Francisco Olarte the above generally does not happen
directly in database. Usually you are using some external program to
convert the binary data into some form of bytea.
>
> Thank you one and all !!
>
> Thanks & Regards
> Naveen
>
>
>
> On Thu, Aug 13, 2020 at 7:34 PM Adrian Klaver <adrian.klaver@aklaver.com
> <mailto:adrian.klaver@aklaver.com>> wrote:
>
> On 8/13/20 6:56 AM, Naveen Kumar wrote:
> > I am not using any programming language. I am simply using
> PostgreSQL 12
> > version that's all
>
> I'm having a hard time figuring out how you are migrating from
> Oracle to
> Postgres without using at least SQL and some sort of driver to pull out
> of one and push into the other.
>
> >
> > On Thu, Aug 13, 2020 at 7:21 PM Adrian Klaver
> <adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
> > <mailto:adrian.klaver@aklaver.com
> <mailto:adrian.klaver@aklaver.com>>> wrote:
> >
> > 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>
> <mailto:adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>>
> > > <mailto:adrian.klaver@aklaver.com
> <mailto:adrian.klaver@aklaver.com>
> > <mailto: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> <mailto:adrian.klaver@aklaver.com
> <mailto:adrian.klaver@aklaver.com>>
> > <mailto:adrian.klaver@aklaver.com
> <mailto:adrian.klaver@aklaver.com> <mailto:adrian.klaver@aklaver.com
> <mailto:adrian.klaver@aklaver.com>>>
> > >
> >
> >
> > --
> > Adrian Klaver
> > adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
> <mailto:adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>>
> >
>
>
> --
> Adrian Klaver
> adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
>
--
Adrian Klaver
adrian.klaver@aklaver.com
On Sun, Aug 16, 2020 at 10:11 AM Naveen Kumar <naveenmcp@gmail.com> wrote:
"PostgreSQL 12.3, compiled by Visual C++ build 1914, 64-bit"I am just trying to practice LOB objects, like byteA data type, in PostgreSQL. Unfortunately, I didn't find good links regarding this so I raised the issue. Nothing else I am doing.
You should supply code that demonstrates what you have tried so far and the errors you are getting (or commented out pseudocode in the places where you are not sure what to write).
David J.