Re: bytea or blobs? - Mailing list pgsql-sql

From Richard Huxton
Subject Re: bytea or blobs?
Date
Msg-id 40BED0EB.8060303@archonet.com
Whole thread Raw
In response to bytea or blobs?  (beyaNet Consultancy <beyanet@ntlworld.com>)
List pgsql-sql
beyaNet Consultancy wrote:
> Hi,
> what I am trying to do is to be able to store images in my database. 
> What I wanted to know is this:
> 
> 1. Would it be better to have the image field type as a bytea or a blob? 
> I have heard it mentioned that bytea would be better as doing data dumps 
> would also insure that the image was saved as well!
> 
> 2. Would it be better to make reference to mp3 files (i.e. storing the 
> address of the image /images/*.jpg)  or is it feasible to store the mp3 
> in the database as bytea or blobs as well?

Depends on the precise details of your situation.

Check the mailing-list archives (this list and general would be a good 
start) for plenty of discussion on these.

--   Richard Huxton  Archonet Ltd


pgsql-sql by date:

Previous
From: Rajesh Kumar Mallah
Date:
Subject: Re: Query becoming slower on adding a primary key
Next
From: "Andrei Bintintan"
Date:
Subject: Reference with condition on other table column?