From: Hilary Forbes <hforbes@dmr.co.uk>
To: Jodi Kanter <jkanter@virginia.edu>
To: Postgres Admin List <pgsql-admin@postgresql.org>
Subject: Re: cross databases?
Date: Thu, 08 Jul 2004 16:46:27 +0100
Message-ID: <5.1.0.14.0.20040708164236.04338eb8@mailserver.dmr.co.uk> (raw)
In-Reply-To: <40ED65D1.6050607@virginia.edu>
<html>
I have often wanted to do this. Years ago, when I was working with
Sybase databases it was perfectly possible. You simply qualified
the table name with a database identifier as I recall eg <br><br>
SELECT m.myfield from second_db.mytable m;<br><br>
The advantages are that you may have two otherwise unconnected systems
which need separately backing up etc but where one uses the other for
lookup purposes (eg a reservations system uses a lookup to an accounts
system to get the customer name and number). <br><br>
I have never understood why postgreSQL hasn't seen this as a priority in
development in more recent months. Maybe someone will enlighten us
both!<br><br>
Hilary<br><br>
At 11:18 08/07/2004 -0400, Jodi Kanter wrote:<br><br>
<blockquote type=cite class=cite cite>I am working with someone who uses
MySQL and says that he has two separate databases in which he can query
across. I am curious if that is something that can be done in postgres?
<br>
Any comments on whether or not that is a good thing?<br>
Thanks<br>
Jodi Kanter<br>
-- <br><br>
<i>_______________________________<br>
Jodi L Kanter<br>
BioInformatics Database Administrator<br>
University of Virginia<br>
(434) 924-2846<br>
<a href="mailto:jkanter@virginia.edu">jkanter@virginia.edu</a></i><br><br>
<br><br>
<i> <br>
</i><br>
<i> </blockquote>
<x-sigsep><p></x-sigsep>
Hilary Forbes<br>
The DMR Information and Technology Group
(<a href="http://www.dmr.co.uk/"; eudora="autourl">www.dmr.co.uk</a>)<br>
Direct tel 01689 889950 Fax 01689 860330 <br>
DMR is a UK registered trade mark of DMR Limited<br>
**********************************************************</i></html>
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: hforbes@dmr.co.uk, jkanter@virginia.edu
Subject: Re: cross databases?
In-Reply-To: <5.1.0.14.0.20040708164236.04338eb8@mailserver.dmr.co.uk>
References: <40ED65D1.6050607@virginia.edu> <5.1.0.14.0.20040708164236.04338eb8@mailserver.dmr.co.uk>
* 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