Re: [trigger] is it possible to launch a shell script? - Mailing list pgsql-novice

From Ludwig Lim
Subject Re: [trigger] is it possible to launch a shell script?
Date
Msg-id 20021010101834.47362.qmail@web80312.mail.yahoo.com
Whole thread Raw
In response to [trigger] is it possible to launch a shell script?  (Grégory Luguet <gregory.luguet@evidian.com>)
List pgsql-novice
--- Gr�gory_Luguet <gregory.luguet@evidian.com> wrote:
> I heard about triggers, but I did not find any way
> to activate something
> else than an SQL procedure with Postgresql ; with
> Oracle I know that I can
> launch nearly whatever I want (including standalone
> sowtware) and I can
> easily write a shell script which would call the
> mysql & insert the data,
> BUT is it possible at all?

 I've read that you can write your trigger procedures
in C. Maybe you can use C system call to call a shell
script. I haven't tried programming stored procedures
in C.

  The following is the section of the manual regarding
triggers

http://www.ca.postgresql.org/users-lounge/docs/7.2/postgres/triggers.html

Hope that helps,
ludwig.



__________________________________________________
Do you Yahoo!?
New DSL Internet Access from SBC & Yahoo!
http://sbc.yahoo.com

pgsql-novice by date:

Previous
From: Grégory Luguet
Date:
Subject: [trigger] is it possible to launch a shell script?
Next
From: John Joseph Bachir
Date:
Subject: postgresql with mac os x --success!!