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 4F98CD1B1B9 for ; Thu, 8 Jul 2004 13:28:40 -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 50434-05 for ; Thu, 8 Jul 2004 16:28:39 +0000 (GMT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id CE922D1B23F for ; Thu, 8 Jul 2004 13:28:38 -0300 (ADT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.12.9/8.12.9) with ESMTP id i68GSci7039803 for ; Thu, 8 Jul 2004 16:28:38 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.12.9/8.12.9/Submit) id i68GBv6q036909 for pgsql-admin@postgresql.org; Thu, 8 Jul 2004 16:11:57 GMT From: Mike Rylander X-Newsgroups: comp.databases.postgresql.admin Subject: Re: cross databases? Date: Thu, 08 Jul 2004 11:55:31 -0400 Organization: Hub.Org Networking Services Lines: 23 Message-ID: References: <40ED65D1.6050607@virginia.edu> Reply-To: miker@purplefrog.com Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7Bit X-Complaints-To: usenet@news.hub.org To: Jodi Kanter User-Agent: KNode/0.7.6 To: pgsql-admin@postgresql.org 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/109 X-Sequence-Number: 14177 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? Postgresql implements SQL standard SCHEMAs which, depending on your exact needs, may serve the same purpose. The other option is the 'contrib/dblink' module. > Any comments on whether or not that is a good thing? In my opinion, SCHEMAs are a beter way than multiple databases to deal with multiple logical datasets that you want to query across. --miker > Thanks > Jodi Kanter