otro
----- Original Message -----
> From: Carlos Peñaranda
> Sent: Wednesday, June 11, 2003 5:38 PM
> Subject: [Pgsql-ayuda] Se puede hacer DBLink?
Exemplo:
-----------------------
tabela1 (codigo integer, nome varchar(50)) //na base1
tabela2 (codigo integer, endereco varchar(50)) //na base 2
SELECT tabela1.codigo, tabela1.nome, tabela2.endereco
FROM tabela1,
dblink('dbname=base2', 'select codigo, endereco from tabela2')
AS tabela2(codigo integer, endereco varchar(50))
WHERE tabela1.codigo = tabela2.codigo
---------------------------------------