Re: binary data storage

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...