bytea or blobs? - Mailing list pgsql-sql

From beyaNet Consultancy
Subject bytea or blobs?
Date
Msg-id E8D7DFA4-5C92-11D8-B55E-0003938366A4@ntlworld.com
Whole thread Raw
Responses Re: bytea or blobs?  (Dana Hudes <dhudes@tcp-ip.info>)
Re: bytea or blobs?  (Jan Wieck <JanWieck@Yahoo.com>)
Re: bytea or blobs?  (Richard Huxton <dev@archonet.com>)
List pgsql-sql
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?

many thanks in adavance



pgsql-sql by date:

Previous
From: "Greg Patnude"
Date:
Subject: Re: determining how many products are in how many categories
Next
From: "Greg Patnude"
Date:
Subject: Re: Unique Constraint with foreign Key