Postgres Pro
Downloads
Home   >   mailing lists

Re: accessing multiple database - Mailing list pgsql-sql

From Richard Huxton
Subject Re: accessing multiple database
Date
Msg-id 4279E5A1.6050103@archonet.com
Whole thread Raw
In response to Re: accessing multiple database  ("mohammad izwan ibrahim" <izwan@orenda.com.my>)
List pgsql-sql
Tree view 
mohammad izwan ibrahim wrote:
> Hi Richard Huxton, Tq for your advice, Hope you can help me on this
> 
> 1.can I  create view from dblink  query

I believe so - see the dblink docs for details.

> 2.can I fetch the data simultaneous from multiple database using
> dblink function, how the syntax would be?

Not in one function-call, but I don't see why you couldn't have several 
sub-queries, each to a different database. I recommend testing it to see.

--   Richard Huxton  Archonet Ltd

pgsql-sql by date:

Previous
From: "mohammad izwan ibrahim"
Date:
Subject: Re: accessing multiple database
Next
From: Listas Evandro (Não use este endereço para mensagens pessoais)
Date:
Subject: Select of a function that returns a array