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]

Subject: Re: How can I insert the image as a blob in the table
From: Rob Sargent <robjsargent@xxxxxxxxx>
Date: Mon, 12 Apr 2021 20:37:46 -0600
Cc: Igor Korot <ikorot01@xxxxxxxxx>, "David G. Johnston" <david.g.johnston@xxxxxxxxx>, "pgsql-generallists.postgresql.org" <pgsql-general@xxxxxxxxxxxxxxxxxxxx>
In-reply-to: <CAA3DN=W1u5VqV8zEd8wHw9qi8-MfGT9g-GCgnPXE2DPHGLTmYw@mail.gmail.com>
References: <CA+FnnTx7XUn28bgVOXHUBeBb+Qorkc-eYikqu55bQ9aq2Z4Kbg@mail.gmail.com> <CAKFQuwaGT1UecowEuwkG3pWmzP_EJdQP=rAZ7iyaQ40wqpi-ZQ@mail.gmail.com> <CA+FnnTy-Liwojw_B-ocFQWif7SWmjoqSwVAOCS29Sd01V9YXWQ@mail.gmail.com> <CAKFQuwY7kAkQCtsRezSma_-QCQO7jHQk1dy9-79OTHuEXRs6-w@mail.gmail.com> <CA+FnnTxoRhUa-gEaDjsd_MRkptzrDDUo+S2d=Gciuip-gNVSxw@mail.gmail.com> <CA+FnnTyRK==VtF3ULTOcG5OYHntGmMHE78XoGfTrcjjCuCQrPg@mail.gmail.com> <CAA3DN=W1u5VqV8zEd8wHw9qi8-MfGT9g-GCgnPXE2DPHGLTmYw@mail.gmail.com>

On Apr 12, 2021, at 8:31 PM, Abdul Qoyyuum <aqoyyuum@xxxxxxxxxxxxxxxxx> wrote:
Have you tried
insert into table(picture) values(lo_import('D:\image.jpg'));
?

No, I’m doing some non-standard compression on the way down.

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

References:
- How can I insert the image as a blob in the table
  - From: Igor Korot
- Re: How can I insert the image as a blob in the table
  - From: David G. Johnston
- Re: How can I insert the image as a blob in the table
  - From: Igor Korot
- Re: How can I insert the image as a blob in the table
  - From: David G. Johnston
- Re: How can I insert the image as a blob in the table
  - From: Igor Korot
- Re: How can I insert the image as a blob in the table
  - From: Igor Korot
- Re: How can I insert the image as a blob in the table
  - From: Abdul Qoyyuum

Prev by Date: Re: How can I insert the image as a blob in the table
Next by Date: Re: The Amazon CloudFront distribution is configured to block access from your country.
Previous by thread: Re: How can I insert the image as a blob in the table
Next by thread: Prepare Statement VS Literal Values
Index(es):
- Date
- Thread

[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]