| From: | Lincoln Yeoh <lyeoh(at)pop(dot)jaring(dot)my> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, drevil(at)sidereal(dot)kz |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Data type for storing images? |
| Date: | 2001-03-13 07:31:21 |
| Message-ID: | 3.0.5.32.20010313153121.009643c0@192.228.128.13 |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-interfaces |
At 08:48 PM 11-03-2001 -0500, Tom Lane wrote:
><drevil(at)sidereal(dot)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
>
>bytea is probably your best bet. The 8k limit is toast in 7.1, btw.
What's bytea ?
How do I store and retrieve 0x00 and other binary stuff like this?
Right now I store stuff like this in files on the filesystem. Storing as
base64 in text doesn't sound attractive :). What are the advantages of
using BLOBs vs files on the filesystem?
Cheerio,
Link.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Huxton | 2001-03-13 07:46:40 | Re: Re: Anyone can create tables! |
| Previous Message | Tom Lane | 2001-03-13 05:07:55 | Re: Re: database access |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | drevil | 2001-03-13 09:00:44 | Re: Data type for storing images? |
| Previous Message | David Wall | 2001-03-13 00:18:21 | JDBC autocommit versus own commits performance |