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

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 HK <timmy(dot)tang(at)gaojin(dot)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(at)yahoo(dot)com
Cell: 310-990-7550
Office: 310-336-5189 Christopher(dot)J(dot)Albertson(at)aero(dot)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