Re: binary data storage

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

In response to

Browse pgsql-general by date

  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