Postgres Pro
Downloads
Home   >   mailing lists

Thread: Accessing objects over db-borders

Accessing objects over db-borders

From
KÖPFERL Robert
Date:
Hi,

Consider one postmaster that manages multiple databases (logical names)

Is it possible (and how) to access a stored procedure or view/Table which
resides in DB aaa if your DB-connection has currently the context on DB bbb?

So: I login on db bbb as a user who has rights on both DBs (aaa,bbb). Can I
do a select on a table of DB aaa?

If this is possible I suspect referential integrity not to work, does it?


Thanks

Re: [despammed] Accessing objects over db-borders

From
Andreas Kretschmer
Date:
am  04.02.2005, um 12:00:17 +0100 mailte KÖPFERL Robert folgendes:
> Hi,
> 
> Consider one postmaster that manages multiple databases (logical names)
> 
> Is it possible (and how) to access a stored procedure or view/Table which
> resides in DB aaa if your DB-connection has currently the context on DB bbb?

Yes, take a look at dblink (contrib-package)


Andreas
-- 
Andreas Kretschmer    (Kontakt: siehe Header)
Heynitz:  035242/47212,      D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net===    Schollglas Unternehmensgruppe    ===