trigger call shell script - Mailing list pgsql-general

From Kenneth Skiles
Subject trigger call shell script
Date
Msg-id 200111031824.NAA14423@www21.ureach.com
Whole thread Raw
List 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.


pgsql-general by date:

Previous
From: "Command Prompt, Inc."
Date:
Subject: Re: Sum(time) possible?
Next
From: Tom Lane
Date:
Subject: Re: Sum(time) possible?