Thread: Accessing other Databases

Accessing other Databases

From
osmar@evaltec.com.br
Date:
Hi all.
Anybody knows some way to access other database inside of a different
database(under the same instalation of postgres)?

Like the example under:
I have two database under the same instalation(database A and B). I am
doing some queries in A - pslq A - and inside A, I want to access, tables,
functions in B, is't possible? ( I know how to do this in Sybase)


Thanks

Osmar


Re: Accessing other Databases

From
Michael Fuhr
Date:
On Mon, Mar 21, 2005 at 11:11:26AM -0300, osmar@evaltec.com.br wrote:
>
> Anybody knows some way to access other database inside of a different
> database(under the same instalation of postgres)?

See the contrib/dblink module.

-- 
Michael Fuhr
http://www.fuhr.org/~mfuhr/