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

From Tom Lane
Subject Re: Data type for storing images?
Date
Msg-id 23574.984361701@sss.pgh.pa.us
Whole thread Raw
In response to Data type for storing images?  (<drevil@sidereal.kz>)
Responses Re: Data type for storing images?
Re: Data type for storing images?
List pgsql-general
<drevil@sidereal.kz> writes:
> 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.

bytea is probably your best bet.  The 8k limit is toast in 7.1, btw.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Anyone can create tables!
Next
From: Dan McGrath
Date:
Subject: Re: Re: Anyone can create tables!