Received: from slip3.raccoon.com (slip3.raccoon.com [165.90.134.130]) by hub.org (8.9.1/8.9.1) with ESMTP id HAA01261 for ; Thu, 21 Jan 1999 07:55:17 -0500 (EST) (envelope-from tim@dmcity.net) Received: from timnt (tim.desmoinesnet.com [165.90.140.11]) by slip3.raccoon.com (8.8.7/8.8.7) with SMTP id GAA30623; Thu, 21 Jan 1999 06:59:42 -0600 Message-ID: <000801be453c$3ae1bf60$0b8c5aa5@timnt.weather.net> Reply-To: "Tim Perdue, The Des Moines City.net" From: "Tim Perdue, The Des Moines City.net" To: "Fabrice Scemama" , Subject: Re: [SQL] Max Length of SQL Date: Thu, 21 Jan 1999 06:47:39 -0600 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 4.72.3110.5 X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3 I've written a Java program that runs every so often (by Cron), then grabs the email, slices and dices it and drops it into PGSQL. It's pretty cool. I'm not sure I understand BLOBS - are they indexable (ie fast searches) and are they stored inside the table? Is the example you gave appropriate for storing text? (looks like graphics?) Tim -----Original Message----- From: Fabrice Scemama To: Tim Perdue, The Des Moines City.net Date: Thursday, January 21, 1999 6:29 AM Subject: Re: [SQL] Max Length of SQL >"Tim Perdue, The Des Moines City.net" wrote: >> >> I'm started to run into a situation where my SQL statements are too long >> (I'm archiving a mailing list into a Postgres table). >> >> What is the max length of a Text field in PostgreSQL? Suggestions for >> working around this besides large objects? >> >> Tim > >The maximal lenght is 8192 cars. >You might need BLOBs instead. Here's an example : > > create table image (name text, raster oid); > insert into image (name, raster) values ('fichier', \ > lo_import('/etc/motd')); > select lo_export(image.raster, '/tmp/motd') from image \ > where name = 'fichier'; > >Hope it helps. >BTW, using Pg to store Mailing lists emais seems interesting. >Do you have a daemon that gets the mails, then parse them and >populate the DB with them ?... > >Fabrice >