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

Поиск
Список
Период
Сортировка
От Grégory Luguet
Тема [trigger] is it possible to launch a shell script?
Дата
Msg-id 00a001c2703a$34bcfcd0$13a2b681@panpan
обсуждение исходный текст
Ответы Re: [trigger] is it possible to launch a shell script?  (Ludwig Lim <lud_nowhere_man@yahoo.com>)
Список 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


В списке pgsql-novice по дате отправления:

Предыдущее
От: Josh Berkus
Дата:
Сообщение: Re: Number Sequence Query
Следующее
От: Ludwig Lim
Дата:
Сообщение: Re: [trigger] is it possible to launch a shell script?