On Sunday, April 11, 2021, David G. Johnston <david.g.johns...@gmail.com> wrote:
> On Sunday, April 11, 2021, Igor Korot <ikoro...@gmail.com> wrote: > >> Hi, David, >> >> >> On Sun, Apr 11, 2021 at 6:24 PM David G. Johnston >> <david.g.johns...@gmail.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? > > Or: https://www.postgresql.org/docs/current/functions-admin.html#FUNCTIONS-ADMIN-GENFILE David J.
