Re: Store / Retrieve image files - Mailing list pgsql-general

From Neil Conway
Subject Re: Store / Retrieve image files
Date
Msg-id 20020614144306.766666a5.nconway@klamath.dyndns.org
Whole thread Raw
In response to Store / Retrieve image files  (chris.gamble@CPBINC.com)
List pgsql-general
On Fri, 14 Jun 2002 11:19:03 -0500
"chris.gamble@CPBINC.com" <chris.gamble@CPBINC.com> wrote:
> I am working on a postgres project that will require me to deal with a lot
> of image files as part of the data. Does postgres handle storing and
> retrieving this type of file efficiently? Does anyone have experience or
> special knowledge on this topic?

BYTEA fields or large objects should both work.

BYTEA: http://developer.postgresql.org/docs/postgres/datatype-binary.html

LOs: http://developer.postgresql.org/docs/postgres/largeobjects.html

Cheers,

Neil

--
Neil Conway <neilconway@rogers.com>
PGP Key ID: DB3C29FC

pgsql-general by date:

Previous
From: "Josh Berkus"
Date:
Subject: Re: [NOVICE] Help required with installing postgreSQL on SCO
Next
From: Arthur Yeo
Date:
Subject: Any alarm-clock features available?