Re: binary data storage

On Thu, 4 Apr 2002 12:36:42 +0300
"Marin Dimitrov"  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 
PGP Key ID: DB3C29FC