Re: selects / joins across db's - Mailing list pgsql-general

From GH
Subject Re: selects / joins across db's
Date
Msg-id 20001229025550.B36676@over-yonder.net
Whole thread Raw
In response to selects / joins across db's  (james shannon <james@motifstudios.com>)
List pgsql-general
On Fri, Dec 29, 2000 at 12:02:45AM -0800, some SMTP stream spewed forth:
> hello...
>    i'm trying to join a table from one database with a table from
> another database(both from the same server). It seems as if postgres
> can't do this.

It is not supported at this time.
I think it is coming at some point in the future though.

gh

>
>    I don't know what the name of what i'm trying to accomplish is,
> but i've seen it done in other databases with 'select * from
> corpdb..table, storedb..table where ...'.
>
>
>    Thanks for any help.
> -- james shannon, james@motifstudios.com on 29/12/2000
>

pgsql-general by date:

Previous
From: "Oliver Elphick"
Date:
Subject: Re: selects / joins across db's
Next
From: "Jarmo Paavilainen"
Date:
Subject: MySQL and PostgreSQL speed compare