Re: How can I insert the image as a blob in the table - Mailing list pgsql-general

From Igor Korot
Subject Re: How can I insert the image as a blob in the table
Date
Msg-id CA+FnnTxoRhUa-gEaDjsd_MRkptzrDDUo+S2d=Gciuip-gNVSxw@mail.gmail.com
Whole thread Raw
In response to Re: How can I insert the image as a blob in the table  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: How can I insert the image as a blob in the table  (Igor Korot <ikorot01@gmail.com>)
List pgsql-general
Hi, David,

On Sun, Apr 11, 2021 at 6:57 PM David G. Johnston
<david.g.johnston@gmail.com> wrote:
>
> On Sunday, April 11, 2021, Igor Korot <ikorot01@gmail.com> wrote:
>>
>> Hi, David,
>>
>>
>> On Sun, Apr 11, 2021 at 6:24 PM David G. Johnston
>> <david.g.johnston@gmail.com> wrote:
>>
>> > If you can decide on what client interface you want to use there should be existing resources on the web walking
throughhow 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.

Thank you.

>
> David J.
>



pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: How can I insert the image as a blob in the table
Next
From: Jan Wieck
Date:
Subject: Re: The Amazon CloudFront distribution is configured to block access from your country.