Re: Using pgsql to archive e-mail

Well, with the next version having toast, what about parsing the email and
storing the body as TEXT?

Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
----- Original Message -----
From: "KuroiNeko" <evpopkov(at)carrier(dot)kiev(dot)ua>
To: <pgsql-general(at)postgresql(dot)org>
Sent: Tuesday, October 24, 2000 5:31 PM
Subject: Re: [GENERAL] Using pgsql to archive e-mail

> > I am looking for a way that I can archieve a lot e-mail messages to
a
> > data
> > base. I'm thinking of using pgsql.
>
> Been there, done that. Works OK for me. Desreves a major rewrite,
because
> storing message bodies as BLOBs is useless and dangerous. If only
there
> were 25 hours in the day (sigh)
> So yes, it's possible. And if you know nothing about DBs and SQL, get
a
> couple of books and start there. There are caveats in a general
email
> archive application, so you'll be better off beginning with
something
> simple.
>
>
> --
>
> contaminated fish and microchips
> huge supertankers on Arabian trips
> oily propaganda from the leaders' lips
> all about the future
> there's people over here, people over there
> everybody's looking for a little more air
> crossing all the borders just to take their share
> planning for the future
>
> Rainbow, Difficult to Cure