Thread: Remote Procedures

Remote Procedures

From
A E
Date:
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

Re: Remote Procedures

From
"Joshua D. Drake"
Date:
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 



Re: Remote Procedures

From
Christopher Kings-Lynne
Date:
Try the contrib/dblink module.

Chris

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"?
>  
> Alex