On Tuesday 14 October 2003 16:38, Edwin Quijada wrote:
> Hi!! Is there a way to execute script in OS from plpgsql???
I think there's a pl/sh procedural language (in contrib or gborg iirc), but
you could probably use any of the untrusted procedural languages.
Better, would be to use the LISTEN/NOTIFY feature to talk to an external
daemon that handles things for you, otherwise your script will run as the
same user as the backend.
--
Richard Huxton
Archonet Ltd