Re: Select from two databases - Mailing list pgsql-sql

From Richard Huxton
Subject Re: Select from two databases
Date
Msg-id 200404221050.03289.dev@archonet.com
Whole thread Raw
In response to Select from two databases  ("Becky Alcorn" <becky@unisolve.com.au>)
List 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 by date:

Previous
From: Richard Huxton
Date:
Subject: Re: rule's behavior with join interesting
Next
From:
Date:
Subject: Re: Order by YYYY MM DD in reverse chrono order trouble