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

From: Rob Sargent <robjsargent(at)gmail(dot)com>
To: Abdul Qoyyuum <aqoyyuum(at)cardaccess(dot)com(dot)au>
Cc: Igor Korot <ikorot01(at)gmail(dot)com>, "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, "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-13 02:37:46
Message-ID: C65AE464-002B-480B-9153-E0F80DA702EF@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> On Apr 12, 2021, at 8:31 PM, Abdul Qoyyuum <aqoyyuum(at)cardaccess(dot)com(dot)au> 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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message felix.quintgz 2021-04-13 04:06:09 Re: The Amazon CloudFront distribution is configured to block access from your country.
Previous Message Abdul Qoyyuum 2021-04-13 02:31:56 Re: How can I insert the image as a blob in the table