Query from 2 data base

From: Roberto Joao Lopes Garcia <roberto(at)mha(dot)com(dot)br>
To: pgsql-sql(at)postgreSQL(dot)org
Subject: Query from 2 data base
Date: 1998-07-31 14:04:51
Message-ID: 3.0.5.32.19980731120451.0088ca30@pop.hipernet.com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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(at)mha(dot)com(dot)br
F. 55 11 848 9906 FAX 55 11 848 9955

MHA Engenharia Ltda
E-mail: mha(at)mha(dot)com(dot)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
-------------------------------------------------------------------

Browse pgsql-sql by date

  From Date Subject
Next Message Stuart logan 1998-07-31 14:41:23 pg_time
Previous Message Daniele Orlandi 1998-07-31 12:26:51 Re: [SQL] What do I need to escape in an Insert ?