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