Re: Where to store Blobs? - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Where to store Blobs?
Date
Msg-id 7e1cf29a-bd11-dba3-2b4a-48080c6bc60d@aklaver.com
Whole thread Raw
In response to Where to store Blobs?  (Thomas Güttler <guettliml@thomas-guettler.de>)
List pgsql-general
On 3/13/19 7:28 AM, Thomas Güttler wrote:
> Some days ago I asked "Where **not** to use PostgreSQL?" on this mailing 
> list.
> 
> Now I realized: Nobody talked about Blobs.
> 
> I guess most people do not store Blobs in PostgresSQL.
> 
> Where do you store Blobs?

Probably the preferred method:
https://www.postgresql.org/docs/11/datatype-binary.html

Another method:
https://www.postgresql.org/docs/11/largeobjects.html

> 
> (In my case Blobs are PDF/image files with size up to 20 MByte.
> I do not talk about very big blobs which are several hundret MByte)
> 
> 
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com


pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: ERROR: XX000: cannot update SecondarySnapshot during a paralleloperation
Next
From: Laurenz Albe
Date:
Subject: Re: Where to store Blobs?