Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id 8882F475AF5 for ; Thu, 9 May 2002 08:08:59 -0400 (EDT) Received: from mailgate5.cinetic.de (mailgate5.cinetic.de [217.72.192.165]) by postgresql.org (Postfix) with ESMTP id DDA28475A50 for ; Thu, 9 May 2002 08:08:57 -0400 (EDT) Received: from web.de (fmomail02.dlan.cinetic.de [172.20.1.46]) by mailgate5.cinetic.de (8.11.2/8.11.2/SuSE Linux 8.11.0-0.4) with SMTP id g49C8nX23321 for pgsql-sql@postgresql.org; Thu, 9 May 2002 14:08:49 +0200 Date: Thu, 9 May 2002 14:08:49 +0200 Message-Id: <200205091208.g49C8nX23321@mailgate5.cinetic.de> MIME-Version: 1.0 Organization: http://freemail.web.de/ From: Bolek Bakowski To: pgsql-sql@postgresql.org Subject: Re: Connection to multiple databases Precedence: fm-user Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Archive-Number: 200205/75 X-Sequence-Number: 7711 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