| From: | Pavel Stehule <stehule(at)kix(dot)fsv(dot)cvut(dot)cz> |
|---|---|
| To: | Philippe Lang <philippe(dot)lang(at)attiksystem(dot)ch> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Shell access & send email from PLPGSQL? |
| Date: | 2003-12-09 10:32:58 |
| Message-ID: | Pine.LNX.4.44.0312091129330.18817-100000@kix.fsv.cvut.cz |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hello
If you require only send mail, try pgsendmail.
http://sourceforge.net/project/showfiles.php?group_id=35804.
You can use plsh too.
http://developer.postgresql.org/~petere/pgplsh/
regards
Pavel Stehule
On Tue, 9 Dec 2003, Philippe Lang wrote:
> Hello,
>
> How can open a unix shell from a PLPGSQL function / trigger?
>
> I would like to send an email from a postgres database, and also send some unix commands to the server, through the database...
>
> Thanks
>
> -------------------------
> Philippe Lang
> Attik System
> http://www.attiksystem.ch
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Shridhar Daithankar | 2003-12-09 10:35:39 | Re: Shell access & send email from PLPGSQL? |
| Previous Message | Gellert, Andre | 2003-12-09 10:22:15 | Reset oid , starting value=1 |