Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Sunday, April 11, 2021, David G. Johnston <david.g.johnston@xxxxxxxxx> wrote:
On Sunday, April 11, 2021, Igor Korot <ikorot01@xxxxxxxxx> wrote:
Hi, David,


On Sun, Apr 11, 2021 at 6:24 PM David G. Johnston
<david.g.johnston@xxxxxxxxx> 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.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux