Re: [despammed] Accessing objects over db-borders

From: Andreas Kretschmer <akretschmer(at)despammed(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: [despammed] Accessing objects over db-borders
Date: 2005-02-04 11:34:17
Message-ID: 20050204113417.GA21742@Pinguin.wug-glas.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 ===

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Richard_D_Levine 2005-02-04 14:11:32 Re: getting back autonumber just inserted
Previous Message KÖPFERL Robert 2005-02-04 11:00:17 Accessing objects over db-borders