| From: | Neil Conway <nconway(at)klamath(dot)dyndns(dot)org> |
|---|---|
| To: | "chris(dot)gamble(at)CPBINC(dot)com" <chris(dot)gamble(at)CPBINC(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Store / Retrieve image files |
| Date: | 2002-06-14 18:43:06 |
| Message-ID: | 20020614144306.766666a5.nconway@klamath.dyndns.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, 14 Jun 2002 11:19:03 -0500
"chris(dot)gamble(at)CPBINC(dot)com" <chris(dot)gamble(at)CPBINC(dot)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(at)rogers(dot)com>
PGP Key ID: DB3C29FC
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Treat | 2002-06-14 18:58:31 | help on qouteing in plpgsql function |
| Previous Message | Tom Lane | 2002-06-14 18:12:13 | Re: I must be blind... |