| From: | Richard Huxton <dev(at)archonet(dot)com> |
|---|---|
| To: | mohammad izwan ibrahim <izwan(at)orenda(dot)com(dot)my> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: accessing multiple database |
| Date: | 2005-05-05 09:21:37 |
| Message-ID: | 4279E5A1.6050103@archonet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Listas Evandro (Não use este endereço para mensagens pessoais) | 2005-05-05 14:27:58 | Select of a function that returns a array |
| Previous Message | mohammad izwan ibrahim | 2005-05-05 09:09:22 | Re: accessing multiple database |