| From: | Richard Huxton <dev(at)archonet(dot)com> |
|---|---|
| To: | "Becky Alcorn" <becky(at)unisolve(dot)com(dot)au>, <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: Select from two databases |
| Date: | 2004-04-22 09:50:03 |
| Message-ID: | 200404221050.03289.dev@archonet.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | ogjunk-pgjedan | 2004-04-22 09:56:48 | Re: Order by YYYY MM DD in reverse chrono order trouble |
| Previous Message | Richard Huxton | 2004-04-22 09:49:01 | Re: rule's behavior with join interesting |