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

Have you tried

insert into table(picture) values(lo_import('D:\image.jpg'));

?

On Tue, Apr 13, 2021 at 9:30 AM Igor Korot <ikorot01(at)gmail(dot)com> wrote:

> Hi, guys,
>
> On Sun, Apr 11, 2021 at 7:08 PM Igor Korot <ikorot01(at)gmail(dot)com> wrote:
> >
> > Hi, David,
> >
> > On Sun, Apr 11, 2021 at 6:57 PM David G. Johnston
> > <david(dot)g(dot)johnston(at)gmail(dot)com> wrote:
> > >
> > > On Sunday, April 11, 2021, Igor Korot <ikorot01(at)gmail(dot)com> wrote:
> > >>
> > >> Hi, David,
> > >>
> > >>
> > >> On Sun, Apr 11, 2021 at 6:24 PM David G. Johnston
> > >> <david(dot)g(dot)johnston(at)gmail(dot)com> 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 interface.
> > >>
> > >> Something like this:
> > >>
> > >> INSERT INTO images(image) VALES( loadfile( /home/igor/my_image) );
> > >>
> > >> Looking to run it from gAdmin in the Terminal.
> > >
> > >
> > > As SQL is executed on the server there is the major issue of the
> server being unable to resolve /home on the client machine. But maybe
> pgAdmin has its own way to deal with this. Have you read its documentation?
> >
> > I don't know - server is running on the same OSX machine as pgAdmin will
> be.
>
> So nobody is playing with the images?
>
> Is it even possible - to insert an image as BLOB into the database
> using a simple
> INSERT INTO query?
>
> Thank you.
>
> >
> > Thank you.
> >
> > >
> > > David J.
> > >
>
>
>

--
Abdul Qoyyuum Bin Haji Abdul Kadir
HP No: +673 720 8043