Thread: Store / Retrieve image files

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?

Thanks

Maybe be a bit of a "hack" answer to your problem but base64 encoding
the images and storing them in text fields has worked for me.

Gavin

-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] On Behalf Of
chris.gamble@CPBINC.com
Sent: Friday, June 14, 2002 9:19 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Store / Retrieve image files

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?

Thanks

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

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