From: | "Tim Perdue, The Des Moines City(dot)net" <tim(at)dmcity(dot)net> |
---|---|
To: | "Fabrice Scemama" <fabrice(dot)scemama(at)gesnet(dot)net>, <pgsql-sql(at)hub(dot)org> |
Subject: | Re: [SQL] Max Length of SQL |
Date: | 1999-01-21 12:47:39 |
Message-ID: | 000801be453c$3ae1bf60$0b8c5aa5@timnt.weather.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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 <fabrice(dot)scemama(at)gesnet(dot)net>
To: Tim Perdue, The Des Moines City.net <tim(at)dmcity(dot)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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Tim Perdue | 1999-01-21 16:08:44 | Re: [SQL] Max Length of SQL |
Previous Message | Walt Bigelow | 1999-01-21 12:46:19 | insert into help |