Recommendation on bytea or blob for binary data like images - Mailing list pgsql-sql

From leon@oss.minimetria.com
Subject Recommendation on bytea or blob for binary data like images
Date
Msg-id 42165.70.34.104.163.1125688546.squirrel@webmail.oss.minimetria.com
Whole thread Raw
Responses Re: Recommendation on bytea or blob for binary data like images
List pgsql-sql
Hi, I'd like to know what the official recommendation is on which binary
datatype to use for common small-binary size use.

I'm working with the Open For Business (www.ofbiz.org) framework, which by
default maps binary data, such as shipping label images, into OID field
types. In general, the data is far less than a gigabyte in size. Is it
strongly recommended by the postgresql community to store things like this
in bytea format as of 8.0?

Thanks,

Leon Torres
leon@oss.minimetria.com
Open Source Strategies
http://opensourcestrategies.com





pgsql-sql by date:

Previous
From: "Owen Jacobson"
Date:
Subject: Re: Turn off auto-commit
Next
From: Tom Lane
Date:
Subject: Re: Recommendation on bytea or blob for binary data like images