Re: Excute comnands OS from plpgsql - Mailing list pgsql-general

From Richard Huxton
Subject Re: Excute comnands OS from plpgsql
Date
Msg-id 200310141715.36627.dev@archonet.com
Whole thread Raw
In response to Excute comnands OS from plpgsql  ("Edwin Quijada" <listas_quijada@hotmail.com>)
Responses Re: Excute comnands OS from plpgsql  (Richard Huxton <dev@archonet.com>)
Re: Excute comnands OS from plpgsql  (Jan Wieck <JanWieck@Yahoo.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Richard Lough
Date:
Subject: Virtual Machines and postgres
Next
From: Jost Richstein
Date:
Subject: Alias-Error