Re: Inserting into the blob - Mailing list pgsql-general

From Igor Korot
Subject Re: Inserting into the blob
Date
Msg-id CA+FnnTx-8TO-ny5UXhHVf8rXwS0vrU9EQtQHv0ZTbAfPz5HbcQ@mail.gmail.com
Whole thread Raw
In response to Re: Inserting into the blob  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: Inserting into the blob
List pgsql-general
Hi, Adrian,

On Sun, Jun 9, 2019 at 11:14 PM Adrian Klaver <adrian.klaver@aklaver.com> wrote:
>
> On 6/9/19 8:28 AM, Igor Korot wrote:
> > Hi, ALL,
> > How do I insert the png file (content, not a name) into the BLOB field
> > in the table i PostgreSQL DB?
>
> Are you talking about this data type?:
>
> https://www.postgresql.org/docs/11/datatype-binary.html
>
> Or this?:
>
> https://www.postgresql.org/docs/11/largeobjects.html

Which one is best to hold an images of unknown size?

>
> What client/language are you using?

psql if possible.

Thank you.

>
>
> >
> > Thank you.
> >
> >
> >
>
>
> --
> Adrian Klaver
> adrian.klaver@aklaver.com



pgsql-general by date:

Previous
From: Igor Korot
Date:
Subject: Inserting into the blob
Next
From: Sourav Majumdar
Date:
Subject: Connection refused (0x0000274D/10061)