X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 2C939D1B195 for ; Thu, 8 Jul 2004 12:48:01 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 26202-01 for ; Thu, 8 Jul 2004 15:47:49 +0000 (GMT) Received: from lorraine.ipl.co.uk (lorraine.ipl.co.uk [195.112.52.123]) by svr1.postgresql.org (Postfix) with ESMTP id 561DDD1B181 for ; Thu, 8 Jul 2004 12:47:47 -0300 (ADT) Received: from HFPORT.dmr.co.uk ([195.112.52.21]) by lorraine.ipl.co.uk (8.12.9/8.12.9) with ESMTP id i68FlOMT024864; Thu, 8 Jul 2004 16:47:26 +0100 Message-Id: <5.1.0.14.0.20040708164236.04338eb8@mailserver.dmr.co.uk> X-Sender: hf1@mailserver.dmr.co.uk X-Mailer: QUALCOMM Windows Eudora Version 5.1 Date: Thu, 08 Jul 2004 16:46:27 +0100 To: Jodi Kanter , Postgres Admin List From: Hilary Forbes Subject: Re: cross databases? In-Reply-To: <40ED65D1.6050607@virginia.edu> Mime-Version: 1.0 Content-Type: text/html; charset="us-ascii" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.6 tagged_above=0.0 required=5.0 tests=HTML_20_30, HTML_MESSAGE, MIME_HTML_ONLY X-Spam-Level: X-Archive-Number: 200407/95 X-Sequence-Number: 14163 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

SELECT m.myfield from second_db.mytable m;

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). 

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!

Hilary

At 11:18 08/07/2004 -0400, Jodi Kanter wrote:

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?
Any comments on whether or not that is a good thing?
Thanks
Jodi Kanter
--

_______________________________
Jodi L Kanter
BioInformatics Database Administrator
University of Virginia
(434) 924-2846
jkanter@virginia.edu


 

 

 

Hilary Forbes
The DMR Information and Technology Group  (www.dmr.co.uk)
Direct tel 01689 889950 Fax 01689 860330
DMR is a UK registered trade mark of DMR Limited
**********************************************************