Received: from simecity.com ([202.188.254.2])
	by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f2D7UZx72927
	for <pgsql-general@postgresql.org>;
	Tue, 13 Mar 2001 02:30:36 -0500 (EST)
	(envelope-from lyeoh@pop.jaring.my)
Received: (from mail@localhost) by simecity.com (8.9.3/8.8.7) id PAA23292;
	Tue, 13 Mar 2001 15:45:25 +0800
Received: from <lyeoh@pop.jaring.my> (ilab2.mecomb.po.my [192.168.3.22]) by
	cirrus.simecity.com via smap (V2.1)
	id xma023290; Tue, 13 Mar 01 15:45:03 +0800
Message-Id: <3.0.5.32.20010313153121.009643c0@192.228.128.13>
X-Sender: lyeoh@192.228.128.13
X-Mailer: QUALCOMM Windows Eudora Light Version 3.0.5 (32)
Date: Tue, 13 Mar 2001 15:31:21 +0800
To: Tom Lane <tgl@sss.pgh.pa.us>, drevil@sidereal.kz
From: Lincoln Yeoh <lyeoh@pop.jaring.my>
Subject: Re: Data type for storing images? 
Cc: pgsql-general@postgresql.org
In-Reply-To: <23574.984361701@sss.pgh.pa.us>
References: <20010311223818.18682.qmail@mailhost.sidereal.kz>
	<20010311223818.18682.qmail@mailhost.sidereal.kz>
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
X-Archive-Number: 200103/560
X-Sequence-Number: 6059

At 08:48 PM 11-03-2001 -0500, Tom Lane wrote:
><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
>
>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.