Skip site navigation (1) Skip section navigation (2)

Re: postgres launch os applications

From: "Sean Davis" <sdavis2(at)mail(dot)nih(dot)gov>
To: "Ertel, Steve" <Steve(dot)Ertel(at)infimatic(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: postgres launch os applications
Date: 2008-10-07 17:34:21
Message-ID: 264855a00810071034r4242332dk3e27693434250ac1@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
On Tue, Oct 7, 2008 at 1:13 PM, Ertel, Steve <Steve(dot)Ertel(at)infimatic(dot)com> wrote:
> I am trying to start an OS executable every time that a table is updated.  I
> know that I should create a trigger on the table, but how do I launch the OS
> executable.  I have a background in sql server.  In it we would use
> something like xsp_execute().  I am looking for the equivalent function call
> in Postgres.

You cannot do this with any "trusted" language (which includes
pg/plsql).  However, you can use any of the untrusted languages like
pl/python, pl/perl, pl/java, pl/tcl, etc.  Of course, each of those
languages has its own specifics dealing with starting executables.

Sean

In response to

Responses

pgsql-novice by date

Next:From: Richard BroersmaDate: 2008-10-07 17:38:50
Subject: Re: postgres launch os applications
Previous:From: Ertel, SteveDate: 2008-10-07 17:13:16
Subject: postgres launch os applications

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group