Postgres Pro
Downloads
Home   >   mailing lists

Re: Store PDF files in PostgreDB - Mailing list pgsql-general

From Ron Johnson
Subject Re: Store PDF files in PostgreDB
Date
Msg-id CANzqJaAGfxm688b1+HryKeo_qkU-1DVP-jKT=DJ1xfbdu5HGeA@mail.gmail.com
Whole thread Raw
In response to Store PDF files in PostgreDB  (Priyadharshini Vellaisamy <priya.cs.pa@gmail.com>)
Responses Re: Store PDF files in PostgreDB  ("Peter J. Holzer" <hjp-pgsql@hjp.at>)
List pgsql-general
Tree view
On Wed, Dec 6, 2023 at 9:39 AM Priyadharshini Vellaisamy <priya.cs.pa@gmail.com> wrote:
Hi Team,

Please let m know can we store PDF files in PostgreDB ?

You can store anything up to 1GB in Postgresql using data type bytea.
 
If so, can we retrieve it effectively?

Effectively?

(We've been storing images in PG for 11 years.)
 

pgsql-general by date:

Previous
From: balasubramanian c r
Date:
Subject: GIN INdex is not used with && operator for a text array index
Next
From: Ron Johnson
Date:
Subject: Max effective number of CPUs that Postgresql can handle?