Re: Can I call unix/linux commands within plsql?

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: Timmy 鄧添喜 <timmy(dot)tang(at)gaojin(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Can I call unix/linux commands within plsql?
Date: 2001-12-13 19:22:12
Message-ID: 20011213112036.M2574-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On Thu, 13 Dec 2001, [big5] Timmy HK wrote:

> Hello,
>
> I'm new to Postgresql/plsql. Can anyone tell me that whether I can
> call unix/linux commands within plsql or not? I need it because some
> functions can not be provided by the PostgreSQL server itself such as
> email.

Not directly. You can do this from C, but you need to be careful,
because anything you do outside of the database is not transaction
safe (ie, if something rolls back the transaction after the function
is called, the outside things are still done even though any data
changes are not recorded).

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message jks 2001-12-13 19:25:03 Re: dropping foreign keys
Previous Message Robert B. Easter 2001-12-13 19:07:39 Re: How to increase shared mem for PostgreSQL on FreeBSD