pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedSelect from two databases
2+ messages / 2 participants
[nested] [flat]
* Select from two databases
@ 2004-04-22 07:00 Becky Alcorn <becky@unisolve.com.au>
2004-04-22 09:50 ` Re: Select from two databases Richard Huxton <dev@archonet.com>
0 siblings, 1 reply; 2+ messages in thread
From: Becky Alcorn @ 2004-04-22 07:00 UTC (permalink / raw)
To: 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.
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Select from two databases
2004-04-22 07:00 Select from two databases Becky Alcorn <becky@unisolve.com.au>
@ 2004-04-22 09:50 ` Richard Huxton <dev@archonet.com>
0 siblings, 0 replies; 2+ messages in thread
From: Richard Huxton @ 2004-04-22 09:50 UTC (permalink / raw)
To: Becky Alcorn <becky@unisolve.com.au>; 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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2004-04-22 09:50 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-04-22 07:00 Select from two databases Becky Alcorn <becky@unisolve.com.au>
2004-04-22 09:50 ` Richard Huxton <dev@archonet.com>
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