From: | Nils Zonneveld <nils(at)mbit(dot)nl> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: SELECT from a table in another database |
Date: | 2001-05-15 22:26:03 |
Message-ID: | 3B01ACE4.2A47F2C6@mbit.nl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
Trygve Falch wrote:
>
> "Nils Zonneveld" <nils(at)mbit(dot)nl> wrote in message
> news:3B015964(dot)AF072405(at)mbit(dot)nl(dot)(dot)(dot)
>
> > AFAIK cross database joins are not possible in PostgreSQL.
>
> Hi! Thanks for the answer.
>
> Actually I think I found 'Allow queries across multiple databases' in the
> TODO-list under something they call 'Exotic feature'. I thought that this
> feature was relativly basic and standard-feature in most DB's.
>
> Maybe I am exotic to need it. *sob*
I don't know what you are using those database for, but nothing prevents
you from letting your clients connect to the different databases the
same time.
I use for instance a MS Access front end (yes, I know but clients
request etc.) to connect to different ODDBC sources and t works just fine.
Another solution is of course to integrate the tables that you need in
your joins in one database.
HTH,
Nils
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2001-05-15 22:47:16 | Re: trouble with the automatic indexes on CREATE TABLE |
Previous Message | Alex Pilosov | 2001-05-15 22:25:31 | index doesn't work for null? |
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2001-05-15 22:27:51 | Re: Configurable path to look up dynamic libraries |
Previous Message | Tom Lane | 2001-05-15 22:23:37 | Re: Configurable path to look up dynamic libraries |