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

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

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adam Rossi 2000-12-28 16:13:31 Re: How I can join between the other database's tables?
Previous Message George Johnson 2000-12-28 15:31:31 Set, SubSelect