| 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: | Whole Thread | Raw Message | 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.
| 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 |