Re: selects / joins across db's

From: GH <grasshacker(at)over-yonder(dot)net>
To: james shannon <james(at)motifstudios(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: selects / joins across db's
Date: 2000-12-29 08:55:50
Message-ID: 20001229025550.B36676@over-yonder.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)motifstudios(dot)com on 29/12/2000
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jarmo Paavilainen 2000-12-29 12:10:43 MySQL and PostgreSQL speed compare
Previous Message Oliver Elphick 2000-12-29 08:22:39 Re: selects / joins across db's