Bytea Example

2020-08-13 Thread Naveen Kumar
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?


Re: Bytea Example

2020-08-13 Thread Naveen Kumar
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 to export the same?
>
> What programming language and database driver are you using?
>
> --
> Adrian Klaver
> adrian.kla...@aklaver.com
>


Re: Bytea Example

2020-08-13 Thread Naveen Kumar
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 language and database driver are you using?
>
> >
> > On Thu, Aug 13, 2020 at 7:17 PM Adrian Klaver  > <mailto:adrian.kla...@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.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com>
> >
>
>
> --
> Adrian Klaver
> adrian.kla...@aklaver.com
>


How to export query results to excel file using psql command in postgresql

2020-08-13 Thread Naveen Kumar
How to export query results to excel file using psql command in postgresql


Re: Bytea Example

2020-08-16 Thread Naveen Kumar
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 
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  > <mailto:adrian.kla...@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
> > mailto:adrian.kla...@aklaver.com>
> >  > <mailto:adrian.kla...@aklaver.com
> > <mailto:adrian.kla...@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.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com>
> > <mailto:adrian.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com
> >>
> >  >
> >
> >
> > --
> > Adrian Klaver
> > adrian.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com>
> >
>
>
> --
> Adrian Klaver
> adrian.kla...@aklaver.com
>