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