Re: pgplpsql and the command line - Mailing list pgsql-novice

From Tom Lane
Subject Re: pgplpsql and the command line
Date
Msg-id 24057.1076187116@sss.pgh.pa.us
Whole thread Raw
In response to pgplpsql and the command line  ("Doug Boyd" <dboyd@raineandhorne.com>)
List pgsql-novice
"Doug Boyd" <dboyd@raineandhorne.com> writes:
> I'm running Postgresql 7.4.1 and pgplsql as a procedural language. I
> want to call a java class from the command line inside a pgplsql
> function and am not sure how to do it.

You can't.  Allowing access to command-line operations would be a
security risk, and plpgsql doesn't provide it.

You could do this in one of the "untrusted" PLs, such as plperlu.
Note that the java program would execute as the database user (eg,
"postgres"), not as the client user as psql's \! would do.

            regards, tom lane

pgsql-novice by date:

Previous
From: Reshat Sabiq
Date:
Subject: Re: RI / foreign key on VIEW
Next
From: Nabil Sayegh
Date:
Subject: Re: RI / foreign key on VIEW