| From: | Zakkr <zakkr(at)zf(dot)jcu(dot)cz> |
|---|---|
| To: | Nikolay Mijaylov <nmmm(at)nmmm(dot)nu> |
| Cc: | pgsql-general(at)postgreSQL(dot)org |
| Subject: | Re: [GENERAL] Many BLOb;s |
| Date: | 1999-10-07 06:32:04 |
| Message-ID: | Pine.LNX.3.96.991007082514.17754A-100000@ara.zf.jcu.cz |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, 7 Oct 1999, Nikolay Mijaylov wrote:
> Hi all,
>
> currently I have project that i;ll use Postgre table with up to 100 000 (or
> more) records, and every record will contain BLOb (Postgre type "oid").
> Every BLOb will be different kind of document, from plain text to GIF or
> JPEG image or some other binary data (MsWord, WP, EXE files etc...)
>
> Is there something risk when I do this? I mean many databases do not support
> BLOb;s too good?
Do you want indexing/search in EXE/WP/M$ files? (Probably no..)
We have in PostgreSQL large object (lo) API for big and "non-scanning" data.
See the tutorial for more information.
Zakkr
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Nikolay Mijaylov | 1999-10-07 07:14:54 | Many BLOb;s |
| Previous Message | Anatoly K. Lasareff | 1999-10-07 06:31:31 | Re: [GENERAL] Alter Table |