X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 1A64AD1E136 for ; Fri, 16 Apr 2004 15:37:18 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 26806-10 for ; Fri, 16 Apr 2004 15:37:12 -0300 (ADT) Received: from trade-india.com (ns5.trade-india.com [66.234.10.13]) by svr1.postgresql.org (Postfix) with SMTP id 63637D1D078 for ; Fri, 16 Apr 2004 15:37:15 -0300 (ADT) Received: (qmail 31769 invoked from network); 16 Apr 2004 15:08:10 -0000 Received: from unknown (HELO trade-india.com) (203.145.130.142) by ns5.trade-india.com with SMTP; 16 Apr 2004 15:08:10 -0000 Message-ID: <408027DE.1070307@trade-india.com> Date: Sat, 17 Apr 2004 00:07:18 +0530 From: Rajesh Kumar Mallah User-Agent: Mozilla Thunderbird 0.5 (X11/20040208) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Pallav Kalva Cc: pgsql-sql@postgresql.org Subject: Re: Querying two databases References: <40801F9F.9020402@deg.cc> In-Reply-To: <40801F9F.9020402@deg.cc> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200404/148 X-Sequence-Number: 17523 hi, its not possible to join cross database tables . you may keep tables in different schemas instead of databases. you may also try contrib/dblink to use tables from different database. Regds mallah. Pallav Kalva wrote: > Hi, > > I am new to postgres and I need to do a query which joins two tables > from different databases. Can you please advice me on how to achieve > this in postgres. > > Thanks! > Pallav > > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faqs/FAQ.html >