<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(at)virginia(dot)edu">jkanter(at)virginia(dot)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>