Remote Procedures

Started by A Eabout 22 years ago3 messages
#1A E
cooljoint@yahoo.com

Hi,

I was wondering is there or will there be support for remote procedures/functions in Postgresql? Not only server to server, but database to database? Such as calling a function in DB "B" from DB "A" or Server Gaia DB "B" from Server Zeus DB "A"?

Alex

#2Joshua D. Drake
jd@commandprompt.com
In reply to: A E (#1)
Re: Remote Procedures

A E wrote:

Hi,

I was wondering is there or will there be support for remote
procedures/functions in Postgresql? Not only server to server, but
database to database? Such as calling a function in DB "B" from DB "A"
or Server Gaia DB "B" from Server Zeus DB "A"?

You could use dblink from contrib.

Sincerely,

Joshua D. Drake

Alex

-- 
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-222-2783 - jd@commandprompt.com - http://www.commandprompt.com
Editor-N-Chief - PostgreSQl.Org - http://www.postgresql.org 
#3Christopher Kings-Lynne
chriskl@familyhealth.com.au
In reply to: A E (#1)
Re: Remote Procedures

Try the contrib/dblink module.

Chris

A E wrote:

Show quoted text

Hi,

I was wondering is there or will there be support for remote
procedures/functions in Postgresql? Not only server to server, but
database to database? Such as calling a function in DB "B" from DB "A"
or Server Gaia DB "B" from Server Zeus DB "A"?

Alex