From: Stephan Szabo <sszabo@megazone23.bigpanda.com>
To: Jiaqing <jjw72@swbell.net>
Cc: pgsql-sql@postgresql.org
Subject: Re: how to refer to tables in another database( or schema as
Date: Mon, 19 Aug 2002 19:56:13 -0700 (PDT)
Message-ID: <20020819195444.G37544-100000@megazone23.bigpanda.com> (raw)
In-Reply-To: <5.1.0.14.0.20020819164709.00a68270@postoffice.swbell.net>
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: sszabo@megazone23.bigpanda.com, jjw72@swbell.net
Subject: Re: how to refer to tables in another database( or schema as
In-Reply-To: <20020819195444.G37544-100000@megazone23.bigpanda.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox