bytea or blobs?

Поиск
Список
Период
Сортировка
От beyaNet Consultancy
Тема bytea or blobs?
Дата
Msg-id E8D7DFA4-5C92-11D8-B55E-0003938366A4@ntlworld.com
обсуждение исходный текст
Ответы 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>)
Список 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 по дате отправления:

Предыдущее
От: "Greg Patnude"
Дата:
Сообщение: Re: determining how many products are in how many categories
Следующее
От: "Greg Patnude"
Дата:
Сообщение: Re: Unique Constraint with foreign Key