Re: binary data storage

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