pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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.&nbsp; Years ago, when I was working with
Sybase databases it was perfectly possible.&nbsp; 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).&nbsp; <br><br>
I have never understood why postgreSQL hasn't seen this as a priority in
development in more recent months.&nbsp; 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>
&nbsp;<br><br>
<i>&nbsp;<br>
</i><br>
<i>&nbsp;</blockquote>
<x-sigsep><p></x-sigsep>
Hilary Forbes<br>
The DMR Information and Technology Group&nbsp;
(<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>




view thread (5+ messages)  latest in thread

Message-ID: <5.1.0.14.0.20040708164236.04338eb8@mailserver.dmr.co.uk>
Permalink:  ../5.1.0.14.0.20040708164236.04338eb8@mailserver.dmr.co.uk/
Also on:    postgresql.org/message-id/5.1.0.14.0.20040708164236.04338eb8@mailserver.dmr.co.uk

 · 

reply

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