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

From Tom Lane
Subject Re: Runnning operating system commands from an SPL
Date
Msg-id 4130.1276787732@sss.pgh.pa.us
Whole thread Raw
In response to Re: Runnning operating system commands from an SPL  (Andreas Kretschmer <akretschmer@spamfence.net>)
List pgsql-novice
Andreas Kretschmer <akretschmer@spamfence.net> writes:
> Atif Jung <atifjung@gmail.com> wrote:
>> 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.

> You can use a un-trusted programming language, for instance pl/perlu or
> plsh.

Keep in mind that more often than not the answer is "you shouldn't do
that".  Commands run in that way will execute as the postgres user,
not as your client user.

            regards, tom lane

pgsql-novice by date:

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