Обсуждение: Connecting to another postgres DB from pg/SQL

Поиск

Список

Период

Сортировка

Connecting to another postgres DB from pg/SQL

От

"Szymanski, Michal (GE Money)"

Дата:

23 ноября 2006 г., 11:33:42

During execution of  PL/pgSQL procedure I have to send somehow few date to another Postgress database. Is to possible
toconnect  
to other database , if yes what is performance of such solution? Is it possible to create DB link between two Postgres
application?

Michał Szymański

Re: Connecting to another postgres DB from pg/SQL

От

"Shoaib Mir"

Дата:

23 ноября 2006 г., 11:59:28

You can use the dblink (http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/dblink/) contrib module for that purpose.

Thanks,
--------
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)

On 11/22/06, Szymanski, Michal (GE Money) < michal.szymanski@ge.com> wrote:

During execution of PL/pgSQL procedure I have to send somehow few date to another Postgress database. Is to possible to connect
to other database , if yes what is performance of such solution? Is it possible to create DB link between two Postgres application?

Michał Szymański

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Вход в личный кабинет

Восстановление пароля

Подтверждение аккаунта

Изменение пароля

Обсуждение: Connecting to another postgres DB from pg/SQL

Connecting to another postgres DB from pg/SQL

Re: Connecting to another postgres DB from pg/SQL