Re: how to refer to tables in another database( or schema as oracle refers to)

Поиск
Список
Период
Сортировка
От Graeme Merrall
Тема Re: how to refer to tables in another database( or schema as oracle refers to)
Дата
Msg-id MMEKJDBHGFPPMNBALCOHMEAMCDAA.GBMerrall@aol.com
обсуждение исходный текст
Ответ на Re: how to refer to tables in another database( or schema as oracle refers to)  ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>)
Список pgsql-sql
> Basically - you can't.  There is a program in the contrib/dblink directory
> that can help you though.
>

My take on this dblink program is to create SQL as a view.
For example coming from Oracle you might do "SELECT one, two, FROM foo.bar".
Convert that to a VIEW called simply "bar" or "foo_bar" that contains your
dblink query and there will be minimal chnages you'll have to make to your
actual code.
This could also be used to get around synonyms as well.

Cheers,Graeme



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

Предыдущее
От: "Christopher Kings-Lynne"
Дата:
Сообщение: Re: Modify column type
Следующее
От: Stephan Szabo
Дата:
Сообщение: Re: how to refer to tables in another database( or schema as