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

On 4/12/21 8:29 PM, Igor Korot wrote:
> Hi, guys,
>
> On Sun, Apr 11, 2021 at 7:08 PM Igor Korot <ikorot01@gmail.com> wrote:
>> 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.
> 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?

psql only understands text input.  Therefore, the image must be text (like 
base64) or hex with a leading "\\x".

-- 
Angular momentum makes the world go 'round.