Message-ID: <431DFA67.4060308@oss.minimetria.com>
Date: Tue, 06 Sep 2005 13:21:59 -0700
From: Leon Torres <leon@oss.minimetria.com>
User-Agent: Debian Thunderbird 1.0.6 (X11/20050802)
MIME-Version: 1.0
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-sql@postgresql.org
Subject: Re: Recommendation on bytea or blob for binary data like images
References: 
 <42165.70.34.104.163.1125688546.squirrel@webmail.oss.minimetria.com>
	<17794.1125693189@sss.pgh.pa.us>
In-Reply-To: <17794.1125693189@sss.pgh.pa.us>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Thanks for the quick response. We will be using bytea from now on. :-)

- Leon

Tom Lane wrote:

>leon@oss.minimetria.com writes:
>  
>
>>Hi, I'd like to know what the official recommendation is on which binary
>>datatype to use for common small-binary size use.
>>    
>>
>
>If bytea will work for you, it's definitely the thing to use.  The only
>real drawback to bytea is that there's currently no API to read and
>write bytea values in a streaming fashion.  If your objects are small
>enough that you can load and store them as units, bytea is fine.
>
>BLOBs, on the other hand, have a number of drawbacks --- hard to dump,
>impossible to secure, etc.
>
>			regards, tom lane
>
>  
>