From: Becky Alcorn <becky@unisolve.com.au>
To: pgsql-sql@postgresql.org
Subject: Select from two databases
Date: Thu, 22 Apr 2004 17:00:52 +1000
Message-ID: <007601c42837$8d675bd0$140010ac@baeckea> (raw)
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: becky@unisolve.com.au
Subject: Re: Select from two databases
In-Reply-To: <007601c42837$8d675bd0$140010ac@baeckea>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox