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

recommendation on bytea or blob for binary data like images

From: leon(at)oss(dot)minimetria(dot)com
To: pgsql-jdbc(at)postgresql(dot)org
Subject: recommendation on bytea or blob for binary data like images
Date: 2005-09-02 16:30:24
Message-ID: 37052.70.34.104.163.1125678624.squirrel@webmail.oss.minimetria.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
Hi, I'd like to know what the official recommendation is on which binary
datatype to use for what situations.

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. Should
this be BYTEA? Is it strongly recommended by the postgresql community to
store things like images in bytea format as of 8.0?

Thanks,

Leon Torres
leon(at)oss(dot)minimetria(dot)com
Open Source Strategies
http://opensourcestrategies.com


pgsql-jdbc by date

Next:From: Andres OlarteDate: 2005-09-02 22:33:57
Subject: Change in parameters' order in prepared statement??
Previous:From: Dave CramerDate: 2005-09-02 13:12:22
Subject: Re: Prepared statement not using an index

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