Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id AA68C476F8E for ; Mon, 21 Oct 2002 10:17:12 -0400 (EDT) Received: from brasileiro.net (slxwy.dorms.usu.edu [129.123.227.56]) by postgresql.org (Postfix) with ESMTP id B3EF547646F for ; Mon, 21 Oct 2002 10:12:51 -0400 (EDT) Received: from roberto by brasileiro.net with local (Exim 3.35 #1 (Debian)) id 183dRN-0003X3-00; Mon, 21 Oct 2002 08:21:57 -0600 Date: Mon, 21 Oct 2002 08:21:57 -0600 From: Roberto Mello To: Tiago Moitinho Cc: pgsql-sql@postgresql.org Subject: Re: Select table from other database Message-ID: <20021021142156.GB13464@cc.usu.edu> References: Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.4i X-message-flag: Please consider using an e-mail program other than Outlook. It's insecure. X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200210/261 X-Sequence-Number: 9978 On Mon, Oct 21, 2002 at 11:54:53AM +0100, Tiago Moitinho wrote: > Hi, > > I would like to know if this is possible: > > I have a database A, with a table X. > Is it possible, being logged in another database (B, for instance), to make > queries using table X from database A? > (something like "SELECT * FROM A.X ...") See the dblink module in the PostgreSQL contrib tree (available via ftp. packages available). -Roberto -- +----| Roberto Mello - http://www.brasileiro.net/ |------+ + Computer Science Graduate Student, Utah State University + + USU Free Software & GNU/Linux Club - http://fslc.usu.edu/ + Sigh. I like to think it's just the Linux people who want to be on the "leading edge" so bad they walk right off the precipice. -- Craig E. Groeschel