Postgres Pro
Downloads
Home   >   mailing lists

Data type for storing images? - Mailing list pgsql-general

From
Subject Data type for storing images?
Date
Msg-id 20010311223818.18682.qmail@mailhost.sidereal.kz
Whole thread Raw
Responses Re: Data type for storing images?
List pgsql-general
Tree view 
I would like to store some images in my Postgres database.  These will
all be thumbnails, limited to 4k or 5k.  I know that PG has an 8k row
limit, but this should be fine, because there's not much else in the
row.  Which data type could I use to store them, and is there a
performance cost for having rows that are this big?  The system will
be using PG7.1, btw.

Thanks

pgsql-general by date:

Previous
From: "Richard Huxton"
Date:
Subject: Re: Anyone can create tables!
Next
From: Marko Kreen
Date:
Subject: [Announce] pgcrypto 0.3 (long)