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 CF983D1B2D9 for ; Thu, 8 Jul 2004 13:01:09 -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 30919-09 for ; Thu, 8 Jul 2004 16:01:05 +0000 (GMT) Received: from anchor-post-32.mail.demon.net (anchor-post-32.mail.demon.net [194.217.242.90]) by svr1.postgresql.org (Postfix) with ESMTP id 37B1CD1B211 for ; Thu, 8 Jul 2004 13:00:59 -0300 (ADT) Received: from mailgate.bray-healthcare.com ([80.177.250.202] helo=solport.bray-healthcare.com) by anchor-post-32.mail.demon.net with esmtp (Exim 3.35 #1) id 1BibKT-0003JT-0W; Thu, 08 Jul 2004 17:00:57 +0100 Received: from [192.168.1.18] (helo=braydb.bray-healthcare.com) by solport.bray-healthcare.com with esmtp (Exim 3.36 #1 (Debian)) id 1BibKQ-0000ba-00; Thu, 08 Jul 2004 17:00:54 +0100 Subject: Re: cross databases? From: Oliver Elphick Reply-To: olly@lfix.co.uk To: Devrim GUNDUZ Cc: Jodi Kanter , Postgres Admin List In-Reply-To: References: Content-Type: text/plain Message-Id: <1089302449.29038.10.camel@braydb> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 Date: Thu, 08 Jul 2004 17:00:49 +0100 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200407/96 X-Sequence-Number: 14164 On Thu, 2004-07-08 at 16:34, Devrim GUNDUZ wrote: > On Thu, 8 Jul 2004, 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? > > Yes, it's possible with PostgreSQL. > > See contrib/dblink. But a more convenient alternative is to use schemas, which MySQL does not (I think) support. Oliver Elphick