pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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





Message-ID: <200205091208.g49C8nX23321@mailgate5.cinetic.de>
Permalink:  ../200205091208.g49C8nX23321@mailgate5.cinetic.de/
Also on:    postgresql.org/message-id/200205091208.g49C8nX23321@mailgate5.cinetic.de

 · 

reply

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