Re: Stored Procedures for Shell Execution

From: Jochem van Dieten <jochemd(at)oli(dot)tudelft(dot)nl>
To: Dustin Dortch <dustin_dortch(at)earthlink(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Stored Procedures for Shell Execution
Date: 2002-06-18 13:02:27
Message-ID: 3D0F2F63.2090600@oli.tudelft.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Dustin Dortch wrote:
> Recently, I have been working on the MCSE certification, and I have been
> studying SQL Server 2000 Administration for one of my electives. Anyhow,
> the reason I mention this is because of some features in SQL Server that I
> think would be great in PostgreSQL. Is there a stored procedure that allows
> for the execution of shell commands? I think it would be great. What I
> would like to accomplish is when a customer is added to my CRM application,
> a script is executed on my shell. Obviously, I woud need to create a
> trigger on my user table and have it run a stored procedure, etc.

PL/sh Procedural Language Handler for PostgreSQL
http://www.ca.postgresql.org/~petere/plsh.html

Jochem

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Beutin 2002-06-18 13:14:29 Re: Wierd Explain
Previous Message Martijn van Oosterhout 2002-06-18 12:25:07 Re: Stored Procedures for Shell Execution