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

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: How can I insert the image as a blob in the table
Дата
Msg-id CAKFQuwa4n58D_RDyzWhiMMgYAQZ3DA=5yDU+b6WZmODeF_P4eA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: How can I insert the image as a blob in the table  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список pgsql-general
On Sunday, April 11, 2021, 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 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:


David J.

В списке pgsql-general по дате отправления:

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: How can I insert the image as a blob in the table
Следующее
От: Igor Korot
Дата:
Сообщение: Re: How can I insert the image as a blob in the table