How to execute a system command inside a SQL statement

Hi all!

I want to execute 'java MyApp' everytime one row is inserted on a table.
What is the correct function to do it?

I want something like this:

CREATE TRIGGER executeJava
AFTER INSERT ON mytable
FOR EACH ROW
BEGIN
SYSTEM('java MyApp');
END;

I suppose SYSTEM('java MyApp') is not correct syntax. What is the correct
syntax to get it? Sorry, I'm relatively new on PostgreSQL.

Anyone can help me, please?
Thank you in advance.

--
View this message in context: http://www.nabble.com/How-to-execute-a-system-command-inside-a-SQL-statement-tf2694802.html#a7515255
Sent from the PostgreSQL - novice mailing list archive at Nabble.com.