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

On Sunday, April 11, 2021, 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?
>
>
Or:

https://www.postgresql.org/docs/current/functions-admin.html#FUNCTIONS-ADMIN-GENFILE

David J.