Re: How I can join between the other database's tables?

From: Adam Rossi <adam(dot)rossi(at)platinumsolutions(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: How I can join between the other database's tables?
Date: 2000-12-28 16:13:31
Message-ID: 00122811133101.00943@SOLO.PSGROUP
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thursday 28 December 2000 11:12 am, Tom Lane wrote:
> Jens Hartwig <jhartwig(at)debis(dot)com> writes:
> > In fact, I also would be very content if PostgreSQL would be enabled to
> > work with different databases (perhaps in some future release?).
>
> I do not think that that's very likely to happen --- at least not in the
> foreseeable future. What is likely to happen for 7.2 is support for
> schemas as defined by the SQL92 standard. Schemas are basically a level
> of naming in between databases and individual tables. By assigning
> separate schemas to each user, you could avoid table naming conflicts
> between users, but it would still be possible to access a table in
> another schema of the same database.
>
> regards, tom lane

Schema support would be a major step forward, and I can't wait to see it
implemented. Thanks for the heads up Tom.

--
Adam Rossi
PlatinumSolutions, Inc.
adam(dot)rossi(at)platinumsolutions(dot)com
http://www.platinumsolutions.com
P.O. Box 31 Oakton, VA 22124
PH: 703.471.9793 FAX: 703.471.7140

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Uro Gruber 2000-12-28 16:21:49 Output function
Previous Message Tom Lane 2000-12-28 16:12:04 Re: How I can join between the other database's tables?