| From: | Howie <caffeine(at)toodarkpark(dot)org> |
|---|---|
| To: | "Jason C(dot) Leach" <jcl(at)mail(dot)ocis(dot)net> |
| Cc: | pgsql-list <pgsql-general(at)hub(dot)org> |
| Subject: | Re: [GENERAL] Mail to DB. |
| Date: | 1999-11-28 22:38:44 |
| Message-ID: | Pine.LNX.3.96.991128223348.372i-100000@rabies.toodarkpark.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Sat, 27 Nov 1999, Jason C. Leach wrote:
> hi,
>
> I've read that a few of you are putting email into a postgres DB. I'd
> be interested in doing something similar. Would any of you care to
> share the secret that allows sendmail to deposit the email to a db, or
> how you get it from /var/spool/mail/mailbox into the table when new mail
> arrives?
a friend and i were just talking about this... you could use procmail to
spawn a program that inserts the data into pgsql. youd most likely want
to use LO's for the email body, storing To:, From:, Cc:, and Subject: in a
table ( for queries ).
---
Howie <caffeine(at)toodarkpark(dot)org> URL: http://www.toodarkpark.org
"Tell a man that there are 400 billion stars and he'll believe you.
Tell him a bench has wet paint and he has to touch it."
| From | Date | Subject | |
|---|---|---|---|
| Next Message | John Henderson | 1999-11-28 23:16:37 | BSDI shared mem |
| Previous Message | Bill Sneed | 1999-11-28 21:21:40 | Quoting/Escaping |