Re: How I can join between the other database's tables? - Mailing list pgsql-general

From Tom Lane
Subject Re: How I can join between the other database's tables?
Date
Msg-id 5303.978019924@sss.pgh.pa.us
Whole thread Raw
In response to Re: How I can join between the other database's tables?  (Jens Hartwig <jhartwig@debis.com>)
Responses Re: How I can join between the other database's tables?
List pgsql-general
Jens Hartwig <jhartwig@debis.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

pgsql-general by date:

Previous
From: Jens Hartwig
Date:
Subject: Re: How I can join between the other database's tables?
Next
From: Adam Rossi
Date:
Subject: Re: How I can join between the other database's tables?