Accessing objects over db-borders - Mailing list 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