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: | Raw Message | Whole Thread | 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 |