| From: | Doug McNaught <doug(at)wireboard(dot)com> |
|---|---|
| To: | Denis Gasparin <denis(at)edistar(dot)com> |
| Cc: | Martín Marqués <martin(at)bugs(dot)unl(dot)edu(dot)ar>, PostgreSQL Mailing Lists-General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: binary data storage |
| Date: | 2002-04-04 15:04:43 |
| Message-ID: | m31ydv33p0.fsf@varsoon.wireboard.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Denis Gasparin <denis(at)edistar(dot)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...
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Doug McNaught | 2002-04-04 16:08:46 | Re: binary data storage |
| Previous Message | Holger Marzen | 2002-04-04 14:52:55 | Re: [NOVICE] readline and psql |