Re: Can I call unix/linux commands within plsql? - Mailing list pgsql-general

From Chris Albertson
Subject Re: Can I call unix/linux commands within plsql?
Date
Msg-id 20011213173843.27233.qmail@web14707.mail.yahoo.com
Whole thread Raw
In response to Can I call unix/linux commands within plsql?  (Timmy 鄧添喜 <timmy.tang@gaojin.com>)
List pgsql-general
There are two ways I can think of

1) Write a Perl, Pyton, C, or C++ program that calls
PostgreSQL and also makes the system calls you need.

2) Write a function (see man create_function) in C.
your C function can do anything.

I'm guessing you should be doing #1.  But tell us your
application if you want better advice.


--- Timmy �H�K�� <timmy.tang@gaojin.com> 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.
>
> Thank you!!
>
> Timmy
>


=====
Chris Albertson
  Home:   310-376-1029  chrisalbertson90278@yahoo.com
  Cell:   310-990-7550
  Office: 310-336-5189  Christopher.J.Albertson@aero.org

__________________________________________________
Do You Yahoo!?
Check out Yahoo! Shopping and Yahoo! Auctions for all of
your unique holiday gifts! Buy at http://shopping.yahoo.com
or bid at http://auctions.yahoo.com

pgsql-general by date:

Previous
From: "colm ennis"
Date:
Subject: Re: slow queries on large syslog table
Next
From: "Marc G. Fournier"
Date:
Subject: Re: How Can I reach the mail archieve ?