Thread: Connecting to another postgres DB from pg/SQL

Connecting to another postgres DB from pg/SQL

From

"Szymanski, Michal (GE Money)"

Date:

23 November 2006, 14: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

From

"Shoaib Mir"

Date:

23 November 2006, 14: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