Received: from hipernet.hipernet.com.br ([200.246.90.126]) by hub.org (8.8.8/8.7.5) with ESMTP id JAA05683 for ; Fri, 31 Jul 1998 09:05:22 -0400 (EDT) Received: from pc15.mha.com.br (dialsp4p9.hipernet.com.br [200.246.90.182]) by hipernet.hipernet.com.br (8.8.8/8.8.8) with SMTP id KAA12067 for ; Fri, 31 Jul 1998 10:00:09 -0300 (EST) Message-Id: <3.0.5.32.19980731120451.0088ca30@pop.hipernet.com.br> X-Sender: roberto@pop.hipernet.com.br X-Mailer: QUALCOMM Windows Eudora Light Version 3.0.5 (32) Date: Fri, 31 Jul 1998 12:04:51 -0200 To: pgsql-sql@postgreSQL.org From: Roberto Joao Lopes Garcia Subject: Query from 2 data base Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hellow all I have 2 data bases: db_1 and db_2 Is it possible, under PostgreSQL, to do a query joining 2 tables one of each database? If not, are there plan in todo list? Exemple: db_1: table city:=20 name char(50), cod_state char(2); db_2: table state: =20 cod_state char(5), name char(50) =20 SELECT db_1.city.name, db_2.state.name FROM db_1.city, db_2.state WHERE db_1.city.cod_state=3Ddb_2.state.cod_state Thank You Roberto ------------------------------------------------------------------ Eng. Roberto Jo=E3o Lopes Garcia E-mail: roberto@mha.com.br F. 55 11 848 9906 FAX 55 11 848 9955 MHA Engenharia Ltda E-mail: mha@mha.com.br WWW: http://www.mha.com.br Av Maria Coelho Aguiar, 215 Bloco D 2 Andar Centro Empresarial de Sao Paulo Sao Paulo - BRASIL - 05805 000 -------------------------------------------------------------------