Re: Post to another db using pl/pgsql

Поиск
Список
Период
Сортировка
От tv@fuzzy.cz
Тема Re: Post to another db using pl/pgsql
Дата
Msg-id 65047.89.102.139.23.1226509337.squirrel@sq.gransy.com
обсуждение исходный текст
Ответ на Post to another db using pl/pgsql  (Robert Fitzpatrick <lists@webtent.net>)
Ответы Re: Post to another db using pl/pgsql  (Robert Fitzpatrick <lists@webtent.net>)
Список pgsql-general
> I've worked with pgsql for a while, but never needed to post from a
> database trigger to another db. Is this possible? And if so, can someone
> offer a pointer to the docs on how to refer to other db's in my script,
> etc?

What do you mean by 'other db'? Does that mean other PostgreSQL database,
or a completely different db (say MySQL for example)?

There is a dblink contrib package - I've never worked with it, but I guess
you can use it to post to a different PostgreSQL db. AFAIK posting to a
MySQL from pl/pgsql is not possible, but you can use pl/perl with proper
packages for example.

regards
Tomas


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

Предыдущее
От: Ivan Sergio Borgonovo
Дата:
Сообщение: Re: sequence not restarting in a for loop (actually semi-random numbers)
Следующее
От: tv@fuzzy.cz
Дата:
Сообщение: Re: Post to another db using pl/pgsql