recommendation on bytea or blob for binary data like images
recommendation on bytea or blob for binary data like images
От:
leon@oss.minimetria.com
Дата:
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@oss.minimetria.com Open Source Strategies http://opensourcestrategies.com