bytea or blobs?

From: beyaNet Consultancy <beyanet(at)ntlworld(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: bytea or blobs?
Date: 2004-02-11 13:05:04
Message-ID: E8D7DFA4-5C92-11D8-B55E-0003938366A4@ntlworld.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Mona 2004-02-11 19:45:12 unsubscribe
Previous Message Mark Gibson 2004-02-11 08:39:24 Re: Elegant way to monitor for changes in a trigger and migrate