Re: binary data storage - Mailing list pgsql-general

From Doug McNaught
Subject Re: binary data storage
Date
Msg-id m31ydv33p0.fsf@varsoon.wireboard.com
Whole thread Raw
In response to Re: binary data storage  (Devrim GUNDUZ <devrim@oper.metu.edu.tr>)
Responses Re: binary data storage  (Denis Gasparin <denis@edistar.com>)
List 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 by date:

Previous
From: Holger Marzen
Date:
Subject: Re: [NOVICE] readline and psql
Next
From: Doug McNaught
Date:
Subject: Re: binary data storage