Re: How can I insert the image as a blob in the table

2021-04-12 Thread Rob Sargent
> On Apr 12, 2021, at 8:31 PM, Abdul Qoyyuum wrote: > > Have you tried > > insert into table(picture) values(lo_import('D:\image.jpg')); > ? > No, I’m doing some non-standard compression on the way down.

Re: How can I insert the image as a blob in the table

2021-04-12 Thread Abdul Qoyyuum
Have you tried insert into table(picture) values(lo_import('D:\image.jpg')); ? On Tue, Apr 13, 2021 at 9:30 AM Igor Korot wrote: > Hi, guys, > > On Sun, Apr 11, 2021 at 7:08 PM Igor Korot wrote: > > > > Hi, David, > > > > On Sun, Apr 11, 2021 at 6:57 PM David G. Johnston > > wrote: > > > >

Re: How can I insert the image as a blob in the table

2021-04-12 Thread Ron
On 4/12/21 8:29 PM, Igor Korot wrote: Hi, guys, On Sun, Apr 11, 2021 at 7:08 PM Igor Korot wrote: Hi, David, On Sun, Apr 11, 2021 at 6:57 PM David G. Johnston wrote: On Sunday, April 11, 2021, Igor Korot wrote: Hi, David, On Sun, Apr 11, 2021 at 6:24 PM David G. Johnston wrote: If

Re: How can I insert the image as a blob in the table

2021-04-12 Thread Rob Sargent
> > On Apr 12, 2021, at 7:29 PM, Igor Korot wrote: > > Hi, guys, > > On Sun, Apr 11, 2021 at 7:08 PM Igor Korot > wrote: >> >> Hi, David, >> >> On Sun, Apr 11, 2021 at 6:57 PM David G. Johnston >> wrote: >>> >>> On Sunday, April 11, 2021, Igor Korot wrote:

Re: How can I insert the image as a blob in the table

2021-04-11 Thread Igor Korot
Hi, David, On Sun, Apr 11, 2021 at 6:57 PM David G. Johnston wrote: > > On Sunday, April 11, 2021, Igor Korot wrote: >> >> Hi, David, >> >> >> On Sun, Apr 11, 2021 at 6:24 PM David G. Johnston >> wrote: >> >> > If you can decide on what client interface you want to use there should be >> >

Re: How can I insert the image as a blob in the table

2021-04-11 Thread David G. Johnston
On Sunday, April 11, 2021, David G. Johnston wrote: > On Sunday, April 11, 2021, Igor Korot wrote: > >> Hi, David, >> >> >> On Sun, Apr 11, 2021 at 6:24 PM David G. Johnston >> wrote: >> >> > If you can decide on what client interface you want to use there should >> be existing resources on

Re: How can I insert the image as a blob in the table

2021-04-11 Thread David G. Johnston
On Sunday, April 11, 2021, Igor Korot wrote: > Hi, David, > > > On Sun, Apr 11, 2021 at 6:24 PM David G. Johnston > wrote: > > > If you can decide on what client interface you want to use there should > be existing resources on the web walking through how to do this using that > client

Re: How can I insert the image as a blob in the table

2021-04-11 Thread Igor Korot
Hi, David, On Sun, Apr 11, 2021 at 6:24 PM David G. Johnston wrote: > > On Sun, Apr 11, 2021 at 2:04 PM Igor Korot wrote: >> >> Hi, ALL, >> I have an image on my hard drive and I'd like to store it in the BLOB >> column of the images table. >> >> Is there a simple SQL to do that in PostgreSQL?

Re: How can I insert the image as a blob in the table

2021-04-11 Thread David G. Johnston
On Sun, Apr 11, 2021 at 2:04 PM Igor Korot wrote: > Hi, ALL, > I have an image on my hard drive and I'd like to store it in the BLOB > column of the images table. > > Is there a simple SQL to do that in PostgreSQL? > > SQL proper has no concept of "your hard drive". You need to define what you