From: | clayton cottingham <drfrog(at)smartt(dot)com> |
---|---|
To: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
Cc: | Jeff Barrett <jbarrett(at)familynetwork(dot)com>, pgsql-sql(at)postgresql(dot)org |
Subject: | Re: calling a shell script from pl/pgsql |
Date: | 2001-09-10 18:44:33 |
Message-ID: | 3B9D0A11.CCD5C785@smartt.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Stephan Szabo wrote:
>
> On Mon, 10 Sep 2001, Jeff Barrett wrote:
>
> > How can I call a shell script from within a pl/pgsql function that is called
> > as from a trigger. I do not want to interact with the script I just want it
> > to run. I do want the trigger to wait for the script it called to complete
> > before returning a value.
> >
> > Any ideas would be greatly appreciated.
>
> I don't think you can do that from within pl/pgsql. You'd probably need a
> function in pl/tclu or c.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
if its typical perl you should be able to
use backticks
my $system=`date`;
$system should be set to the date
or if you dont need any data back as you say
then just
system('date');
From | Date | Subject | |
---|---|---|---|
Next Message | Jeff Barrett | 2001-09-10 19:15:50 | Re: calling a shell script from pl/pgsql |
Previous Message | Alex Pilosov | 2001-09-10 18:24:31 | Re: pl/sh (was Re: calling a shell script from pl/pgsql) |