Accessing objects over db-borders

From: KÖPFERL Robert <robert(dot)koepferl(at)sonorys(dot)at>
To:
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Accessing objects over db-borders
Date: 2005-02-04 11:00:17
Message-ID: ED4E30DD9C43D5118DFB00508BBBA76EB165AB@neptun.sonorys.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Andreas Kretschmer 2005-02-04 11:34:17 Re: [despammed] Accessing objects over db-borders
Previous Message Michael Glaesemann 2005-02-04 05:02:20 Re: Determining Rank