From: Bolek Bakowski <b-bakowski@web.de>
To: pgsql-sql@postgresql.org
Subject: Re: Connection to multiple databases
Date: Thu, 9 May 2002 14:08:49 +0200
Message-ID: <200205091208.g49C8nX23321@mailgate5.cinetic.de> (raw)
how can I solve following problem:
On a standalone Linux-PC I wish to locate several
databases in the directory ../pgsql/data, viz:
1. readers_DATABASE with about 20 tables
the readers_TABLE has follwing fields:
readers_id
readers_name
...
...
2. publication_DATABASE with about 40 tables
the publication_TABLE has following fields:
publication_id
publication_description
readers_id
...
...
3. other_DATABASE
4. ...
Is it possible to make following query:
SELECT publication_description FROM publication_DATABASE.publication_TABLE
WHERE publication_DATABASE.publication_TABLE.readers_id =
readers_DATABASE.readers_TABLE.readers_id;
or have I to put all tables in one database.
b-bakowski@web.de
________________________________________________________________
Keine verlorenen Lotto-Quittungen, keine vergessenen Gewinne mehr!
Beim WEB.DE Lottoservice: http://tippen2.web.de/?x=13
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: b-bakowski@web.de
Subject: Re: Connection to multiple databases
In-Reply-To: <200205091208.g49C8nX23321@mailgate5.cinetic.de>
* 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