Select from two databases - Mailing list pgsql-sql

From Becky Alcorn
Subject Select from two databases
Date
Msg-id 007601c42837$8d675bd0$140010ac@baeckea
Whole thread Raw
Responses Re: Select from two databases  (Richard Huxton <dev@archonet.com>)
List pgsql-sql
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?

Regards
Becky

Becky Alcorn
Unisolve Pty Ltd - Melbourne, Australia
+61 3 9568 2005

This line intentionally left blank.



pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: Join issue on a maximum value
Next
From: "Vincent Ladlad"
Date:
Subject: Re: staggered query?