From: | Neil Conway <nconway(at)klamath(dot)dyndns(dot)org> |
---|---|
To: | devrim(at)oper(dot)metu(dot)edu(dot)tr |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: binary data storage |
Date: | 2002-04-04 16:34:06 |
Message-ID: | 20020404113406.765b985e.nconway@klamath.dyndns.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Thu, 4 Apr 2002 12:36:42 +0300
"Marin Dimitrov" <marin(dot)dimitrov(at)sirma(dot)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(at)rogers(dot)com>
PGP Key ID: DB3C29FC
From | Date | Subject | |
---|---|---|---|
Next Message | virka prasetia | 2002-04-04 17:10:56 | installation problem |
Previous Message | Doug McNaught | 2002-04-04 16:08:46 | Re: binary data storage |