Andreas Kretschmer <akretschmer(at)spamfence(dot)net> writes:
> Atif Jung <atifjung(at)gmail(dot)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
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
In response to
pgsql-novice by date
|Next:||From: Atif Jung||Date: 2010-06-17 15:19:20|
|Subject: Re: Runnning operating system commands from an SPL|
|Previous:||From: A B||Date: 2010-06-17 15:14:24|
|Subject: How to combine many rows into one row (by concatenation?) ?|