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@carrier.kiev.ua>
To: <pgsql-general@postgresql.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