On Thu, 4 Apr 2002 12:36:42 +0300
"Marin Dimitrov" <marin.dimitrov@sirma.bg> wrote:
>
> ----- 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
You could also use a column with datatype "bytea", and the libpq
function PQescapeBytea().
Cheers,
Neil
--
Neil Conway <neilconway@rogers.com>
PGP Key ID: DB3C29FC