Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 9F7969FC290 for ; Fri, 18 May 2007 12:59:11 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 46643-03 for ; Fri, 18 May 2007 12:59:08 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from exchange.g2switchworks.com (mail.g2switchworks.com [63.87.162.25]) by postgresql.org (Postfix) with ESMTP id 620F49FC29F for ; Fri, 18 May 2007 12:59:08 -0300 (ADT) Received: from [10.10.1.37] ([10.10.1.37]) by exchange.g2switchworks.com with Microsoft SMTPSVC(6.0.3790.1830); Fri, 18 May 2007 10:59:07 -0500 Message-ID: <464DCD4B.6030904@g2switchworks.com> Date: Fri, 18 May 2007 10:59:07 -0500 From: Scott Marlowe User-Agent: Thunderbird 1.5.0.4 (X11/20060516) MIME-Version: 1.0 To: Jessica Richard CC: pgsql-admin@postgresql.org Subject: Re: cross database references... References: <920543.35507.qm@web56405.mail.re3.yahoo.com> In-Reply-To: <920543.35507.qm@web56405.mail.re3.yahoo.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-OriginalArrivalTime: 18 May 2007 15:59:07.0617 (UTC) FILETIME=[77553D10:01C79965] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/193 X-Sequence-Number: 25513 Jessica Richard wrote: > Other than dblink, is there any other way to let me joint select two > tables in two different databases? Would schemas work for you? You can have multiple schemas in one database (like oracle) so that you references tables as schemaname.tablename etc... Works well for most places you need to do this.