Postgres Pro
Downloads
Home   >   mailing lists

Re: Runnning operating system commands from an SPL - Mailing list pgsql-novice

From Jasen Betts
Subject Re: Runnning operating system commands from an SPL
Date
Msg-id hvfdi1$ljj$1@reversiblemaps.ath.cx
Whole thread Raw
In response to Runnning operating system commands from an SPL  (Atif Jung <atifjung@gmail.com>)
List pgsql-novice
Tree view 
On 2010-06-17, Atif Jung <atifjung@gmail.com> wrote:
> --0016e6db2979ca8a9d04893aae3a
> Content-Type: text/plain; charset=ISO-8859-1
>
> How do I run an operating system command from a stored procedure? In
> INFORMIX I would use the SYSTEM command, can't see to find the equivalent
> for POSTGRES.
>
> I'm running AIX6.1.

PLPGSQL doesn't allow that. use one of the untrusted languages:
C, PLPERLU, PLTCLU, etc...

pgsql-novice by date:

Previous
From: Tim Landscheidt
Date:
Subject: Re: How to combine many rows into one row (by concatenation?) ?
Next
From: Atif Jung
Date:
Subject: Re: Runnning operating system commands from an SPL