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
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 |