Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pdxpug by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group