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@xxxxxxxxx> wrote:
Hi, guys,
On Sun, Apr 11, 2021 at 7:08 PM Igor Korot <ikorot01@xxxxxxxxx> wrote:
>
> Hi, David,
>
> On Sun, Apr 11, 2021 at 6:57 PM David G. Johnston
> <david.g.johnston@xxxxxxxxx> wrote:
> >
> > On Sunday, April 11, 2021, Igor Korot <ikorot01@xxxxxxxxx> wrote:
> >>
> >> Hi, David,
> >>
> >>
> >> On Sun, Apr 11, 2021 at 6:24 PM David G. Johnston
> >> <david.g.johnston@xxxxxxxxx> 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
