Re: [despammed] Accessing objects over db-borders - Mailing list pgsql-sql

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    ===