Re: Store PDF files in PostgreDB

From: Ron Johnson <ronljohnsonjr(at)gmail(dot)com>
To: Priyadharshini Vellaisamy <priya(dot)cs(dot)pa(at)gmail(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Store PDF files in PostgreDB
Date: 2023-12-06 14:43:27
Message-ID: CANzqJaAGfxm688b1+HryKeo_qkU-1DVP-jKT=DJ1xfbdu5HGeA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Dec 6, 2023 at 9:39 AM Priyadharshini Vellaisamy <
priya(dot)cs(dot)pa(at)gmail(dot)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.)

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ron Johnson 2023-12-06 14:55:52 Max effective number of CPUs that Postgresql can handle?
Previous Message balasubramanian c r 2023-12-06 14:32:52 GIN INdex is not used with && operator for a text array index