| From: | Darko Prenosil <darko(dot)prenosil(at)finteh(dot)hr> |
|---|---|
| To: | Peter Choe <choepete(at)mindspring(dot)com>, "pgsql-general" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: accessing two databases at the same time |
| Date: | 2003-03-05 21:58:05 |
| Message-ID: | 200303052158.05213.darko.prenosil@finteh.hr |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wednesday 05 March 2003 20:17, Peter Choe wrote:
> if i have database 'A' with a table called 'a' and another database 'B'
> with a table called 'b', is there a way to do a select using both databases
> and their tables?
>
> select * from A.a, B.b;
>
See the dblink in contrib directory or
if You are familyar with postgres libpq client interface, look at
ftp://gborg.postgresql.org/pub/plpq/devel/plpq_src.tar.gz
> Peter Choe
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Medi Montaseri | 2003-03-05 21:59:36 | Re: accessing two databases at the same time |
| Previous Message | Jan Wieck | 2003-03-05 21:52:01 | Re: My employment with PeerDirect |