Shema functionality in 7.3

From: "Mikael Carneholm" <SA9625(at)ida(dot)utb(dot)hb(dot)se>
To: pgsql-general(at)postgresql(dot)org
Subject: Shema functionality in 7.3
Date: 2002-12-01 22:24:32
Message-ID: E18IcW6-0001qW-00@mother.hb.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Can someone who has experience from the new 7.3 version tell me
if

SELECT tableA.foo
FROM shema1.tableA, shema2.tableB
WHERE tableA.bar = tableB.bar

is possible thanks to the new schema functionality? And is it
possible to grant users permissions on whole schemas?

Queries like the one above is possible in Oracle, and I would really
like to see this in PostgreSQL as well. (I guess we could call this
feature "cross schema joins".)

Note: I would not consider this as crossdb functionality, as tableA
and tableB exist in the same database (using Oracle terms: the
same instance), but in different shemas.

---------------------------------------------------------
Mikael Carneholm, M.Sc.
The University College of Boras, Sweden
Email: mikael(dot)carneholm(at)ida(dot)utb(dot)hb(dot)se

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Han Holl 2002-12-01 22:39:29 Re: Memory leak with palloc
Previous Message Tom Lane 2002-12-01 22:09:34 Re: Memory leak with palloc