Received: from marketingchallenge.com (marketingchallenge.com [64.40.111.205] (may be forged)) by postgresql.org (8.11.3/8.11.4) with SMTP id f8AIgQ738546 for ; Mon, 10 Sep 2001 14:42:26 -0400 (EDT) (envelope-from drfrog@smartt.com) Received: (qmail 22818 invoked from network); 10 Sep 2001 18:42:09 -0000 Received: from clayton-cottingham.imc (HELO smartt.com) (10.1.4.1) by marketingchallenge.com with SMTP; 10 Sep 2001 18:42:09 -0000 Message-ID: <3B9D0A11.CCD5C785@smartt.com> Date: Mon, 10 Sep 2001 11:44:33 -0700 From: clayton cottingham X-Mailer: Mozilla 4.76 [en] (X11; U; Linux 2.2.17-21mdk i686) X-Accept-Language: en MIME-Version: 1.0 To: Stephan Szabo CC: Jeff Barrett , pgsql-sql@postgresql.org Subject: Re: calling a shell script from pl/pgsql References: Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200109/42 X-Sequence-Number: 4688 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@postgresql.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');