Re: Cross-database tables - Mailing list pgsql-novice

From Brett W. McCoy
Subject Re: Cross-database tables
Date
Msg-id Pine.LNX.4.30.0101062111580.8905-100000@chapelperilous.net
Whole thread Raw
In response to Cross-database tables  (Ron Johnson <rjohnson@rjohnson.com>)
Responses Re: Cross-database tables
List pgsql-novice
On Sat, 6 Jan 2001, Ron Johnson wrote:

> I'd love it if I could access tables from other databases.
>
> Is there a way to do this?
>
> Here's some sample pseudo-SQL in case I wasn't clear about that:
>
>     select * from database1^table3, database2^table4;

Is this the same as what in SQL92 are known as 'logical schemas' (versus
the physical schema)?  They aren't supported yet in PostgreSQL, but are in
the TODO list, according to http://www.postgresql.org/docs/todo.html,
under exotic features. hmm...  distributed queries (via replication) are
listed in there as well.  Cool.

-- Brett
                                     http://www.chapelperilous.net/~bmccoy/
---------------------------------------------------------------------------
I'd never join any club that would have the likes of me as a member.
        -- Groucho Marx


pgsql-novice by date:

Previous
From: Ron Johnson
Date:
Subject: Cross-database tables
Next
From: Ron Johnson
Date:
Subject: Re: Cross-database tables