Re: Running OS-level programs from Postgres?

If you can use tcl based pl function, the this might help you here -->
http://sourceforge.net/projects/pgmail/

--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)

On 6/20/07, Joshua D. Drake <jd(at)commandprompt(dot)com> wrote:
>
> Sean Murphy wrote:
> > Maybe this is a well duh kind of question, or maybe there's no
> > straightforward way to do it, but is there any way that I could have a
> > pg function initiate a process on the host system?
>
> Yeah you can use any of the untrusted pl languages for that.
>
> >
> > Specifically I'd like to script an email to send off on an insert
> > trigger, but the ability to initiate system processes in general seems
> > like it would come in handy.
> >
> > My present need is for email notification; if there's a pg function or
> > module that would handle this (I haven't turned up anything in my
> > searches, but maybe I'm using the wrong search terms in the wrong
> > places) I'd be OK for now, but I'd rather have the flexibility of
> > starting whatever process a given circumstance calls for.
> >
> > Thanks.
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 2: Don't 'kill -9' the postmaster
> >
>
>
> --
>
> === The PostgreSQL Company: Command Prompt, Inc. ===
> Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
> Providing the most comprehensive PostgreSQL solutions since 1997
> http://www.commandprompt.com/
>
> Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
> PostgreSQL Replication: http://www.commandprompt.com/products/
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org/
>