Re: Select from two databases

Поиск
Список
Период
Сортировка
От Richard Huxton
Тема Re: Select from two databases
Дата
Msg-id 200404221050.03289.dev@archonet.com
обсуждение исходный текст
Ответ на Select from two databases  ("Becky Alcorn" <becky@unisolve.com.au>)
Список pgsql-sql
On Thursday 22 April 2004 08:00, Becky Alcorn wrote:
> Hi,
>
> I was wondering if there has been any further development on running SQL
> statements involving more than one database?  We are porting a database
> from SQLServer to Postgres and some queries in related applications use
> joins on tables that are in different databases.  We know we can modify the
> code to use dblink to accomplish much the same thing in Postgres.  Does
> anyone know of a more elegant solution for Postgres than dblink?

The standard response to this is to suggest using schemas. Any reason why this 
won't work in your case?

--  Richard Huxton Archonet Ltd


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

Предыдущее
От: Richard Huxton
Дата:
Сообщение: Re: rule's behavior with join interesting
Следующее
От:
Дата:
Сообщение: Re: Order by YYYY MM DD in reverse chrono order trouble