[postgis-users] Install postgis on a different schema

[P Kishor]

On Tue, Nov 24, 2009 at 5:19 PM, Kevin Neufeld <kneufeld at refractions.net> wrote:
>  So if you issued
> SELECT * FROM mytable;
> in this case Postgres would look first in public, then in shared, then in
> project1 and then project2 for "mytable"...
>
> Hope this helps,


Ok. It almost helps. One thing I don't understand though -- when you
say "Postgres would look first in public...," that would be in case of
a query such as

SELECT * FROM mytable;

But, if I were to say

SELECT * FROM <schema>.mytable;

then all this is moot, no?

I am in the habit of fully qualifying most everything, so I shouldn't
have to bother with search paths, no?


-- 
Puneet Kishor