From: | Igor Korot <ikorot01(at)gmail(dot)com> |
---|---|
To: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
Cc: | "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | Re: How can I insert the image as a blob in the table |
Date: | 2021-04-12 00:08:33 |
Message-ID: | CA+FnnTxoRhUa-gEaDjsd_MRkptzrDDUo+S2d=Gciuip-gNVSxw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi, David,
On Sun, Apr 11, 2021 at 6:57 PM 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?
I don't know - server is running on the same OSX machine as pgAdmin will be.
Thank you.
>
> David J.
>
From | Date | Subject | |
---|---|---|---|
Next Message | Zhihong Yu | 2021-04-12 02:33:34 | Re: Have I found an interval arithmetic bug? |
Previous Message | David G. Johnston | 2021-04-12 00:02:06 | Re: How can I insert the image as a blob in the table |