Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 174D7475AD7 for ; Mon, 21 Oct 2002 06:54:52 -0400 (EDT) Received: from hotmail.com (f77.law9.hotmail.com [64.4.9.77]) by postgresql.org (Postfix) with ESMTP id 658AD475461 for ; Mon, 21 Oct 2002 06:54:51 -0400 (EDT) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Mon, 21 Oct 2002 03:54:53 -0700 Received: from 80.90.198.59 by lw9fd.law9.hotmail.msn.com with HTTP; Mon, 21 Oct 2002 10:54:53 GMT X-Originating-IP: [80.90.198.59] From: "Tiago Moitinho" To: pgsql-sql@postgresql.org Subject: Select table from other database Date: Mon, 21 Oct 2002 11:54:53 +0100 Mime-Version: 1.0 Content-Type: text/plain; format=flowed Message-ID: X-OriginalArrivalTime: 21 Oct 2002 10:54:53.0780 (UTC) FILETIME=[49584140:01C278F0] X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200210/257 X-Sequence-Number: 9974 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 ...") Thanks in advance Tiago _________________________________________________________________ Get a speedy connection with MSN Broadband.  Join now! http://resourcecenter.msn.com/access/plans/freeactivation.asp