Accessing objects over db-borders

Поиск
Список
Период
Сортировка
От KÖPFERL Robert
Тема Accessing objects over db-borders
Дата
Msg-id ED4E30DD9C43D5118DFB00508BBBA76EB165AB@neptun.sonorys.at
обсуждение исходный текст
Ответы Re: [despammed] Accessing objects over db-borders  (Andreas Kretschmer <akretschmer@despammed.com>)
Список 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


В списке pgsql-sql по дате отправления:

Предыдущее
От: "Peter Manchev"
Дата:
Сообщение: Re: plpgsql functions to 'C' functions
Следующее
От: Andreas Kretschmer
Дата:
Сообщение: Re: [despammed] Accessing objects over db-borders