Re: Bytea Example

On Sun, Aug 16, 2020 at 10:11 AM Naveen Kumar 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

Re: Bytea Example

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 P

Re: Bytea Example

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 wrote: > 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

Re: Bytea Example

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 aske

Re: Bytea Example

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 wrote: > I am connected t

Re: Bytea Example

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

Re: Bytea Example

On Thursday, August 13, 2020, 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? > At a simple level its no different than importing and exporting character data using a “text/

Re: Bytea Example

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

Re: Bytea Example

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

Re: Bytea Example

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 > wrote: On 8/13/20 6:40

Re: Bytea Example

I am trying to migrate the database from Oracle to PostgreSQL On Thu, Aug 13, 2020 at 7:17 PM Adrian Klaver 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

Re: Bytea Example

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.kla...@aklaver.com

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?