[trigger] is it possible to launch a shell script?

From: Grégory Luguet <gregory(dot)luguet(at)evidian(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: [trigger] is it possible to launch a shell script?
Date: 2002-10-10 08:51:21
Message-ID: 00a001c2703a$34bcfcd0$13a2b681@panpan
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hello all,

I have to synchronize the content of 2 databases, each one being used by an
application from our Information System ; unfortunately these apps require a
specific DBMS : one needs MySQL and the other Postgresql.
Now I want the mysql database to be updated with the data from Postgresql
when this one is updated itself.

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?

Thank you in advance for your answers, remarks and suggestions.

Faithfully yours,
Grégory Luguet

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Ludwig Lim 2002-10-10 10:18:34 Re: [trigger] is it possible to launch a shell script?
Previous Message Devinder K Rajput 2002-10-09 21:38:51 Re: Number Sequence Query