Re: Select from two databases

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