Re: How to execute a system command inside a SQL statement

> 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?

I am not sure sure how you could go about doing this.  If you do not get the answer you are
looking for on this list you might try the pg_general mailing list.

Here is the only thing that I can think of that might work for you:
http://pgfoundry.org/projects/pljava/

Regards,

Richard Broersma Jr.