Re: [Pgsql-ayuda] Se puede hacer DBLink?

----- Original Message -----
> From: Carlos Peñaranda Sent: Wednesday, June 11, 2003 5:38 PM
> Subject: [Pgsql-ayuda] Se puede hacer DBLink?

> Existe en Postgres la posibilidad de hacer un DBLink como lo hace Oracle o SQL Server?

acabo de recibir, espero te sirva... (esta en portugues ..pero se entiende.)

--------------------------------------------------
--Consultar

SELECT * FROM dblink('dbname=pgteste hostaddr=210.174.40.63 user=pano
password=aaa port=5432','SELECT id, nome
from clientes') AS t1(id integer, nome varchar(30));

--Consultar remoto e criar uma tabela local

CREATE TABLE clientes_remoto AS SELECT * FROM dblink('dbname=pgteste
hostaddr=200.174.40.63 user=pano password=ass port=5432','SELECT id, nome
from clientes') AS t1(id integer, nome varchar(30));

--Inserir/atualizar/excluir
SELECT dblink_exec('dbname=pgteste hostaddr=200.174.40.63 user=pano
password=aaa port=5432','INSERT INTO clientes (nome) VALUES (''Neimar
Volpini'')');

--------------------------------------------------

------------------------------------------------------------------------------
Do you Yahoo!?
Free online calendar with sync to Outlook(TM).