Re: Storing Binary Large Objects

From: "David E(dot) Wheeler" <david(at)kineticode(dot)com>
To: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
Cc: pdxpug(at)postgresql(dot)org
Subject: Re: Storing Binary Large Objects
Date: 2007-03-29 03:54:49
Message-ID: 246337ED-22C2-4413-8F79-6B80E724A7AA@kineticode.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pdxpug

On Mar 28, 2007, at 18:31, Rich Shepard wrote:

> So, to store .pdf files I'd use the oid data type, yes? I'll read
> up on
> that.

I think I'd use the bytea type for files that are relatively small—
say up to 256K or something, and maybe smaller. Otherwise I'd use the
lo_* functions (although they are rather a PITA). How big are these
PDFs you need to manage?

Best,

David

In response to

Responses

Browse pdxpug by date

  From Date Subject
Next Message Rich Shepard 2007-03-29 13:16:00 Re: Storing Binary Large Objects
Previous Message Rich Shepard 2007-03-29 01:31:16 Re: Storing Binary Large Objects