From: Roberto Joao Lopes Garcia <roberto@mha.com.br>
To: pgsql-sql@postgreSQL.org
Subject: Query from 2 data base
Date: Fri, 31 Jul 1998 12:04:51 -0200
Message-ID: <3.0.5.32.19980731120451.0088ca30@pop.hipernet.com.br> (raw)
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:
name char(50),
cod_state char(2);
db_2:
table state:
cod_state char(5),
name char(50)
SELECT db_1.city.name, db_2.state.name FROM db_1.city, db_2.state WHERE
db_1.city.cod_state=db_2.state.cod_state
Thank You
Roberto
------------------------------------------------------------------
Eng. Roberto João 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
-------------------------------------------------------------------
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: roberto@mha.com.br
Subject: Re: Query from 2 data base
In-Reply-To: <3.0.5.32.19980731120451.0088ca30@pop.hipernet.com.br>
References: <3.0.5.32.19980731120451.0088ca30@pop.hipernet.com.br>
* 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