| From: | "Marin Dimitrov" <marin(dot)dimitrov(at)sirma(dot)bg> |
|---|---|
| To: | "Devrim GUNDUZ" <devrim(at)oper(dot)metu(dot)edu(dot)tr>, "PostgreSQL Mailing Lists-General" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: binary data storage |
| Date: | 2002-04-04 09:36:42 |
| Message-ID: | 006701c1dbbc$3ae930a0$9b0e32d4@sirma.bg |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
----- Original Message -----
From: "Devrim GUNDUZ"
>
> Hi,
>
> Let's say we have 100 MB of binary file (for example, a zip file). How
> could we store this file in PostgreSQL? Which datatype could we use and
> how do we insert it?
>
search for "large objects" in the Programmer's Guide (
http://www.ca.postgresql.org/users-lounge/docs/#7.2 )
in your case Large Objects (chapter 2 from the Programmer's Guide) may be
more appropriate than binary strings (chapter 3.4 from the User's Guide)
hth,
Marin
----
"...what you brought from your past, is of no use in your present. When
you must choose a new path, do not bring old experiences with you.
Those who strike out afresh, but who attempt to retain a little of the
old life, end up torn apart by their own memories. "
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Devrim GUNDUZ | 2002-04-04 09:42:27 | Re: binary data storage |
| Previous Message | Mark kirkwood | 2002-04-04 07:45:29 | Re: Re : Solaris Performance - Profiling (Solved) |