trigger call shell script

From: Kenneth Skiles <kaskiles(at)ureach(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: trigger call shell script
Date: 2001-11-03 18:24:09
Message-ID: 200111031824.NAA14423@www21.ureach.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I'm thinking of having a trigger launch a java program.
My plan is to make the trigger execute a command line java class, basically
the trigger should type this into the console:

'java DoWork 1403'

Where 'DoWork' is the name of my java class that takes a command line
argument 'itemid' which is 1403 in this case.

Can command line programs/scripts be called from Postgresql functions?
Can anyone provide example code for making the Postgresql function that
executes a command line statement?

Thanks, Kenneth.

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-11-03 18:26:08 Re: Sum(time) possible?
Previous Message Domingo Alvarez Duarte 2001-11-03 18:16:55 Re: Porting Web application written in Oracle 8 PL/SQL to Postgresql