Connection to multiple databases

From: Bolek Bakowski <b-bakowski(at)web(dot)de>
To: pgsql-admin(at)postgresql(dot)org
Subject: Connection to multiple databases
Date: 2002-05-06 18:35:45
Message-ID: 200205061835.g46IZjX27744@mailgate5.cinetic.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

hi,

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.

Thanks
b-bakowski(at)web(dot)de

________________________________________________________________
Keine verlorenen Lotto-Quittungen, keine vergessenen Gewinne mehr!
Beim WEB.DE Lottoservice: http://tippen2.web.de/?x=13

Browse pgsql-admin by date

  From Date Subject
Next Message Brian McCane 2002-05-06 18:49:07 Re: SERIAL Field
Previous Message Dan Langille 2002-05-06 18:25:21 Re: SERIAL Field