Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 98660475E02 for ; Mon, 19 Aug 2002 22:56:10 -0400 (EDT) Received: from megazone.bigpanda.com (megazone.bigpanda.com [63.150.15.178]) by postgresql.org (Postfix) with ESMTP id 4B7CD475DE3 for ; Mon, 19 Aug 2002 22:56:09 -0400 (EDT) Received: by megazone.bigpanda.com (Postfix, from userid 1001) id AF941D610; Mon, 19 Aug 2002 19:56:13 -0700 (PDT) Received: from localhost (localhost [127.0.0.1]) by megazone.bigpanda.com (Postfix) with ESMTP id A54415C04; Mon, 19 Aug 2002 19:56:13 -0700 (PDT) Date: Mon, 19 Aug 2002 19:56:13 -0700 (PDT) From: Stephan Szabo To: Jiaqing Cc: Subject: Re: how to refer to tables in another database( or schema as In-Reply-To: <5.1.0.14.0.20020819164709.00a68270@postoffice.swbell.net> Message-ID: <20020819195444.G37544-100000@megazone23.bigpanda.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200208/286 X-Sequence-Number: 9132 On Mon, 19 Aug 2002, Jiaqing wrote: > Hello, > I'm still new here and new to PostgreSQL, I'd like to know that after I > have created two databases on my site, such as one is called backend, and > another one is called admin, how do I refer(query) the table from backend > while I'm connected to admin database, or is it possible to do that in > PostgreSQL? any answer is appreciated. In addition to previous answers (dblink related), in 7.3 schemas will be implemented and you may be able to use one database with two schemas in which case normal sql should work. This isn't out yet, so it's a future concern.