Re: binary data storage

Поиск
Список
Период
Сортировка
От Doug McNaught
Тема Re: binary data storage
Дата
Msg-id m31ydv33p0.fsf@varsoon.wireboard.com
обсуждение исходный текст
Ответ на Re: binary data storage  (Devrim GUNDUZ <devrim@oper.metu.edu.tr>)
Ответы Re: binary data storage  (Denis Gasparin <denis@edistar.com>)
Список pgsql-general
Denis Gasparin <denis@edistar.com> writes:

> Hi Martin,
>     I discourage you to use the large object data type for a file of such
> dimensions... It would be better for you to store in the db the filename
> and the path to the file itself.

Why?

>     However you can find the large object you've inserted in your data
> directory (subdirectory base/oid of your database/).

Large objects are stored in a single table, not individual files.

-Doug
--
Doug McNaught       Wireboard Industries      http://www.wireboard.com/

      Custom software development, systems and network consulting.
      Java PostgreSQL Enhydra Python Zope Perl Apache Linux BSD...

В списке pgsql-general по дате отправления:

Предыдущее
От: Holger Marzen
Дата:
Сообщение: Re: [NOVICE] readline and psql
Следующее
От: Doug McNaught
Дата:
Сообщение: Re: binary data storage